Forum Discussion
Adding a SSAS data model as a data set in a workspace
Hi jtrock ，
Power BI Service mainly used to share and consume business insights, it can only connect to a very limited number of data sources.
However, Power BI Desktop can connect to other large variety of data sources. For SSAS, in Desktop, select Get Data> Database> SQL Server Analysis Services database.
After you create a report based on the SSAS data model, publish it to Power BI Service, it will produce the corresponding published dataset.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,
I guess I am not explaining myself correctly?
We have 100+ existing reports that were created in Power BI Desktop by initially selecting a data source using Get Data -> Power BI Data Sets, and then the content creator selected our SSAS model (let's call it SSAS Model A) from one of many workspaces that had it as a published data set back before that was deprecated.
Now we have SSAS Model B, which is a development model. How can we switch a subset of existing reports to use SSAS Model B as a data source? I can go into Options and settings -> Data source settings, but it will only let me change to a different published data set within the list of workspaces I have access to.
If SSAS Model B were a published data set already in a workspace, this would be no problem. But at this point, adding it as a data set to a workspace has been deprecated.
So what are the recommended steps to point existing reports already using SSAS Model A as a published data set in a workspace to SSAS Model B that is not a published data set in a workspace because Microsoft took away that ability?
Is there a gap here that Microsoft hasn't addressed, and I am stuck re-creating reports from scratch by going to Get Data -> Analysis Services and typing in the name of the server and the SSAS Model B model and then having to re-create everything, including custom measures, etc.?
There used to be a way where you could change the .pbix extension to a .zip extension and then open it as a ZIP archive and see all of the internal XML files and maybe hack a data source change that way -- not sure if that still works or not.
When I go to Options and settings -> Data source settings, instead of just assuming I want to select another data source from Power BI Datasets, it should give us the option to reselect the type of data source, so at that point I can choose Analysis Services instead, and then get a prompt to enter the server name and then select the model. That would also resolve my issue.