Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I have created the following model in Visual Studio as shown in the snapshot below.
I have then deployed that model in Azure Analysis Services (again as shown in the snapshot below)
So far so good. My problem occurs when I try to load the model in Power BI Desktop with the Import option (Connect Live works fine but I also want to add the data). My problem is that all the fields are loaded under Model and not into their respective tables (the tables are lost only appearing in front of the respective fields like product.produckey and all of the under model)! Is there a workaround to make all the tables load separately ?
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
So it is interesting that you mentioned that. The project I created in Visual Studio is an Analysis Services Tabular Project. But you are right it seems that somehow when I deployed the model in Azure AS and then tried to load it into Power BI using import it got changed to a cube for some reason?
Is there a way to load it as a tabular model instead or does that change happen automaticaly so the only solution is to load the tables separately?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |