Feels like this should be more strait forward, but we have a report, semantic model and data storage, in this case a DW. We have a prod and non prod for each, so 2 workspaces. I would like to just change the connection string on the semantic model to point to our prod connection but I don't have the option in the drop down even though exists, also if I do create new, it doesn't update this one or allow me to, just creates a new connection and closes. Am I doing something wrong here?

I have over 26 Excel files, each named in the format DPI-YYYY-MM-DD (e.g., DPI-2023-01-06, DPI-2023-01-20, DPI-2023-02-03, etc.). Each file contains seven sheets (Sheet 1 to Sheet 7), and I need to load them into a Data Warehouse in MS Fabric. What would be the most efficient and ideal approach to accomplish this? Any suggestions?

Hi folks, having quite a few errors with G2 Dataflows, even when using a .pqt and importing the exact G1 df to a G2 its failing substantially, Ive been trying a bunch of stuff with switching of Fast copy/Enable Staging, and writing to a LH or not, even when its at its most simple form it seems to fail. Granted there is a bit going on in this DF, originally it was 4 merges in each of 2 queries and then a join. Ive moved half to a notebook but there still seems to be considerable issues and differences, just wondering if others are experiencing the same issues? my final state will move all of the transform to a NB, but surely DF's should still perform as G1! Similar issues: https://community.fabric.microsoft.com/t5/Service/Dataflow-Gen2-Issue/m-p/3275868 https://community.fabric.microsoft.com/t5/Dataflow/Couldn-t-refresh-the-entity-because-of-an-issue-with-the-mashup/m-p/3506887 https://community.fabric.microsoft.com/t5/Dataflow/Gen2-Dataflow-Failed-to-insert-a-table/m-p/3372458 Additional questions: do Dataflows use Datafactory in the background? this would make sense if the schemas are not perfect, it needs the same treatment as delta schema rules etc. why cant the errors be more helpful?! Cheers Ross

I am using a notebook to load an Excel file (downloaded from a website) into a folder in the Files area of a lakehouse - I thought this would be pretty straightforward, but I must be missing something: from datetime import datetime import pandas as pd url = "https://<url_of_excel_file" output_path = "Files/sales_targets/" + datetime.now().strftime("%Y%m%d") # load Excel file from URL and replace spaces in column names df = pd.read_excel(url) df.columns = df.columns.str.replace(' ','') # create directory if it doesn't exist mssparkutils.fs.mkdirs(output_path) df.to_excel(output_path + "/targets.xlsx") Is df.to_excel the correct method here, or should I be using PySpark instead?

Hey everyone, I know many of you are currently struggling to get started with Fabric. You can provide Microsoft with some valuable feedback to share your experiences about getting started with Fabric, and the free trial experience: Feedback form for new Fabric developers: https://aka.ms/FabricGettingStartedFeedbackDoc?wt.mc_id=onboardingresearch_includes_content_cnl_learncomm Hopefully we can make it a better experience for all.