Uploading Excel files from Fabric Lakehouse storage to OneDrive or SharePoint
I have a Pipeline with multiple Notebooks that ingest and transform data into a data frame that gets saved into an Excel file on the Data Lake storage. My client wants to access these reports into their own PowerBI. I was thinking of making this possible by implementing a Copy Data step in the pipeline for copying the generated Excel files into something like OneDrive or SharePoint which in turn can be used for loading it into PowerBI. Does this approach make sense or is there a better way to go about loading Data Frames / Excel reports into PowerBI?
Issues setting up Synapse VS code on VS desktop
Hi there, Hoping someone might be able to assist with setting up Synapse VS code on my VS desktop. The issue I have is that I don't have the "synapse-spark-kernel" created. Instead I have a couple of other kernels "fabric-synapse-runtime". .. and neither seems to execute spark on the Jupyter notebook Basically I have followed all the processes here, https://learn.microsoft.com/en-us/fabric/data-engineering/setup-vs-code-extension
Default Semantic Model - Unable to remove table
I'm trying to remove the table called "dim_location" from my Lakehouse's default semantic model. I uncheck the dim_location table and click Confirm. However, after I click Confirm, the dim_location table is still in the default semantic model: The dim_location table is also still in the Data ribbon of the Power BI Report. So it definitely seems the dim_location table has not been removed from the Default semantic model: If I click Manage default semantic model again, then I can see that the table is actually included, even if I previously unchecked it and clicked Confirm. Is anyone else experiencing this? I'm currently experiencing this in multiple workspaces, with multiple different default semantic models.
Syncing a Azure DevOps git repo into another empty workspace fails
I am currently trying to sync an exisiting azure devops git repository containing workspace items (lakehouses, notebooks, data pipelines), which we commited from an existing workspace to the repo, into another, empty workspace, after moving the whole azure organisation to the customer: When doing so, I get this error: This is the overview of the repo content (not much in it): Would you have any suggestions on how to resolve that issue? Is it a matter of missing dependencies within the pipeline? If so, how can I investigate what is missing?
Impossble de créer un modèle sémantique supplément lié au Lkehouse
Bonjour, Lorsque je finis la création de mon lakehouse et du modèle sémantique par defaut. si je veux générer un autre modèle sémantique, le systeme me renvoit ce message d'erreur : "Une erreur inattendue s’est produite lors de la distribution de la création du modèle sémantique au gestionnaire d’actions du portail.".Performance difference between default semantic model and custom (new) semantic model?
Hi, Is there a difference in performance between using the Lakehouse's default semantic model, or creating a new direct lake semantic model (also known as custom semantic model)? Ref. this blog: "The Default dataset is also performance optimized. I have seen in some cases, default dataset perform faster in cold cache compared to custom dataset. I am not sure why." Thank you!Default dataset of the lakehouse is not getting updated
Hi , I am updating the datatype of column name year ( from string to int). The change is getting reflected in my lakeshouse table but not in my default dataset. I am geting error when i updating dataset of the powerBI? Unable to update BI model with these changes. Please try again later or contact support. The column type change from 'String' to 'Int64' is not allowed for Direct Lake table column '<ccon>Year</ccon>'['<ccon>fact_cost_monthly</ccon>']. Please choose a compatible data type or exclude the column. See https://go.microsoft.com/fwlink/?linkid=2215281 to learn more. Please try again later or contact support. If you contact support, please provide these details. Datatype in my lakeshouse : In Default Dataset in fabric ( it is still string) :Developing Dashboards from FnO Data
Hi, I am developing Power BI Dashboard in Fabric. My flow of Data is from, FnO to Dataverse to Microsoft Fabric (As Shortcut Tables, here data is not present in OneLake, It is present in Dataverse Environment). My Requirement is to Develop a dashboard on top of it. I have came to know about two methods: 1. Using SQL End-Point - Creating a visual query, choosing specified columns, replacing values, etc.. and then saving as a view (The required view alone saves in OneLake). If needed we can also create a measure for the same in SQL EndPoint. 2. Using Notebooks on Lakehouse - Using a Notebook, loading tables as df, making transformations and then saving the same (Here the transformed gets saved in OneLake) (We can run notebooks at specified intervals, such that once data gets refreshed in Dataverse, it gets refreshed in Dashboard). Is there any common persona to use, both Replace Feature (From SQL Endpoint) and the New Calculated Column Feature (From Warehouse). I would like to know about the Warehouse Method, where I can get like the below mentioned image. If possible, I would like to know if I should use all the tables in OneLake or is there any way to use the transformed tables alone in OneLake. (I have taken this image from Semantic Model) Below image is for Visual Query in SQL Endpoint Kindly assist me with all the possible ways and the solution of creating measures, calculated fields, etc.. all possible solutions with SQL Endpoint Notebooks and Warehouse methods, since fabric is a fresh perspective. And, if I bring my data into datawarehouse using the "+" options, will that cause storing data into OneLake, or the same will come as a Shortcut tables (I believe data doesn't gets duplicated into OneLake here) Any Assistance on this will be highly helpful. Thanks in Advance.
