Forum Discussion
Power BI Desktop Import Sql Server Analysis Service Tabular Model issues
In my PB Desktop, I am connecting with "Import" mode to a basic Tabular SSAS model with just a Dimension table and a Fact Table based on the AdventureWorks sql database 2019. I have built the model...
The requirement is the possibility to connect to Analysis Service and to connect also to an Excel file so the only possibility is to cnnect to Analysis Service in import mode
Have you considered cutting Power BI out of the picture and connecting to SSAS directly from Excel?
I tryed from Excel and it works, but I must do the report on Power BI