dataflows
3 TopicsBUG::Fabric semantic model not accessible from Power BI Desktop
Issue: After creating and populating a lakehouse successfully, I can connect to it from Power BI Desktop by selecting Power BI semantic models in the Get data dropdown from the Home tab. Power BI Desktop version is December 2023 and I am using trial mode. Here is the result after connection and selection of the lakehouse: As you can see, the Data pane never populates and as a result, I can't drag and drop from the lakehouse tables. This worked in a previous test with a different workspace and lakehouse. However, click on Get data from another source -->, which is in the middle of the page when you start a new report, and you get this dialog: Click Add a local model, and you get a dialog showing the lakehouse: Select the lakehouse and click Submit... and nothing happens. Same result as before. I also tried Get data-->More... and same result as well. What's going on?Solved1.5KViews0likes4CommentsFabric migration: architecture
We currently have a DataFactory V2 running, but have also started to explore Fabric. Current Fabric WIP architecture: FundamentalWorkSpace Warehouse: Date dimension SQL table (existing) Lakehouse: Shortcut to date dimension SQL table in warehouse (existing) Reason for both lakehouse and warehouse, is cross workspace access to lakehouse data. SalesOfferWorkspace KQL DB: SalesOfferDimension table (existing KQL table, data from pipeline) SalesOfferRaw (existing KQL table, data from pipeline) To be decided: SalesOfferFact table In the old dataplatform, all dimensions and facts are gathered in one big semantic PBI model/ dataset. Starting fresh in Fabric, I would like to experiment with isolating concepts in workspaces, for self-serving PBI report building etc. There are so many architectural options in Fabric. How or where would you create the SalesOfferFacts table, given that it has to join sales offers, dates, accounting periods etc? EDIT: the contributors in the SalesOffer workspace are citizen (?) PBI report builders, they just need easy access to a star schema semantic model from PBI Desktop.894Views0likes3Comments