Solved Data Modeling Issue Microsoft Fabric Community Since yesterday, we’re encountering major issues refreshing our semantic models in microsoft fabric. we consistently receive the following error: failed to save modifications to the server. The semantic model has one table and the data source is lakehouse, connected using the sql endpoint. it doens't seem like a permission issue because i created the connection in the data pipeline activity using my own user which has fabric tenanat admin permissions. tried changing different semantic models, different data sources still no luck.
Data Modeling Issue Microsoft Fabric Community So, when i go to combine the sources, it looks like the data from the "rare ocassion" table is missing for months it wasn't refreshed in. see below table for example: now, if i have a date slicer from my calendar table, select feb 23, agent will appear blank. I have used the sample data on my end and successfully implemented it. i am also including .pbix file for your better understanding, please have a look into it: hope this will help you resolve your issue, if you need any further assistance, feel free to reach out. thank you for using microsoft community forum. Here, we remove the current filter context just for the date column of the date table. that column was also the one we were using in the visual itself meaning it was the one applying the filter onto the calculations. I hope someone can help. i`m trying to put together a dashboard on promotions in my organisation and i`m having some issues with the data model.
Solved Data Modeling Microsoft Fabric Community Here, we remove the current filter context just for the date column of the date table. that column was also the one we were using in the visual itself meaning it was the one applying the filter onto the calculations. I hope someone can help. i`m trying to put together a dashboard on promotions in my organisation and i`m having some issues with the data model. What's probably happening: every time someone clicks a slicer, power bi is generating separate queries to both sources, pulling data back, then trying to merge it. that's why your caching isn't helping much. real fixes: split the **bleep** thing separate reports for bigquery vs sql data. stop trying to make them play nice together in one model. Check service status, browse learning resources, and get technical support for fabric and its components: power bi, data factory, data engineering, data science, data warehouse, databases and real time analytics. Before submitting a support request, review this list to see if the issue that you are experiencing is already known and being addressed. fixed issues are removed after 46 days. you can use the table maintenance feature to manage delta tables in fabric. This article provides information about how to troubleshoot common issues with link to fabric with microsoft dataverse.
Comments are closed.