data modeling
6 TopicsProblem with model in Fabric DW + pb in pipelines
Hello, I am trying to work on my datawarehouse, but I have several problems. Everything was running well before my holidays, but now I am unable to create relation, remove table in default dataset (I don't even see the defaut dataset layout) etc... Here the several errors that I have: - I don't see the default dataset layout anymore. When I try to Manage the default dataset (adding a new table), here the type of error that I have: Unable to update BI model with these changes. Please try again later or contact support. You cannot change the storage mode of partition '<ccon>XXXXX</ccon>'. Converting existing tables or partitions from Import or DirectQuery mode to Direct Lake is not supported. See https://go.microsoft.com/fwlink/?linkid=2215281 to learn more. - Trying to hide a table: " Something went wrong {"code":"ArgumentException","message":"Item '<ccon>XXXX</ccon>' already exists in the collection."} Please check the technical details for more information. If you contact support, please provide these details." - Trying to create a new relation: {"code":"ArgumentException","message":"Item '<ccon>XXXX</ccon>' already exists in the collection."} I also see "Stripes" on the top of my tables in the model view (I don't remember it was like that before my holidays) Also, the date refreshed for all tables is the same, and is wrong (1/1/1, 12:09:21 AM). Also a bug in pipelines: when I load data, and there is a problem with a NULL (by example if I try to load data with null in a column that don't accept null), it's not the good column name that is displayed in the error message ( I have seen that it happened few months ago in Synapse, seems like the same bug). What is happening? Is it possible to have some help?Solved6.7KViews0likes19CommentsEdit Microsoft S3 shortcuts in Lakehouse
We have been testing Microsoft Fabric and Shortcuts from S3, a feature that allows us to create and manage shortcuts to data sources in Onelake Lakehouse. However, we have encountered some problems with deleting S3 shortcuts and updating shortcuts with new credentials. We have tried to follow the instructions from the official documentation, but we have not been able to resolve these issues. We would like to ask if anyone knows a solution or if this is a limitation in S3 shortcuts to Onelake Lakehouse.1KViews0likes3CommentsImporting Data to Fabric Lakehouse using DF Gen2 on Tables with _ creates temporary Tables
We use the On-Prem Data Gateway to get Data from an On-Prem SQL Server in a Dataflow Gen 2 top store tables in the Azure Lakehouse. When having Tables containing an "_" in the name (e.g. ABTEILUNG_T) it results in strage table structure on the Lakehouse: Expeted here would be ABTEILUNG_T, AKTIVITAET_T only. As soon as i get rid of the "_" in the dataflow query settings -> Name. It works. Renaming worked for us, but should be fixedSolved1.3KViews0likes2CommentsFabric Warehouse model layout tabs not saving
I created a Fabric Warehouse. I added a new tab in the Model view and dragged several tables/views into the layout. After adding another view, I get an error that "Unable to sync the warehouse with the default Power BI dataset. Some reports may not be updated. To try to repair this, refresh your browser and open the warehouse again." and the newly created tab disappears. I close the DW and refresh the browser. When I open the DW and go to the Model view, the only tab is "All Tables" When will I be able to create layout tabs in the Model view in Fabric??1.4KViews1like1Comment