Change datasource from SSAS to Power BI Dataset

[Cookistador]

Hello Everyone,

I am facing a new issue, currently we have some SSAS Cubes, and we would like to upgrade them in power BI services.
We don't want to use XMLA endpoint due to the fact we cannot download the PBI to modify the datasets

So after a few tests, I was able to create a new version of this cube with tabular editor and a blank power BI, I updated it in Power BI services, and now everything is working perfectly

So now, I'm facing a new issue, is there a way to change the connector of my report which use SSAS connection to Power BI Datasets?

Currently, I saw 2 posts to achieve this, the first one was to convert the PBIX in zip and copy the connection, but it doesn't wrork anymore, and the second options is using a script via API but this approach requires XMLA endpoint (it is not my case) (https://data-marc.com/2021/09/29/swap-connection-from-analysis-services-to-power-bi-dataset/)

Any idea of what could I try?

Many thanks for your help 

[v-cazheng-msft · Accepted solution]

Hi @Cookistador,

AFAIK, in addition to the solutions you mentioned, you may consider achieving it by calling the update dataset datasource rest api by the try it option in this link:  Datasets - Update Datasources In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs. To call this rest api, there are some requirements and limitations.

Permissions

• The user must be the dataset owner.
• This API call can be called by a service principal profile. For more information see: Service principal profiles in Power BI Embedded.

Required Scope:

Dataset.ReadWrite.All

Limitations

• Datasets created using the public XMLA endpoint aren't supported. To make changes to those data sources, the admin must use the Azure Analysis Services client library for Tabular Object Model.
• Only these data sources are supported: SQL Server, Azure SQL Server, Azure Analysis Services, Azure Synapse, OData, SharePoint, Teradata, and SAP HANA. For other data sources, use the Update Parameters In Group API call.
• Changing the data source type isn't supported.
• Data sources that contain parameters in the connection string aren't supported.
• Updating data sources that are part of merged or joined tables is only supported if you're using enhanced dataset metadata.
• For an Advanced Query that reference multiple data sources, only the first data source will be updated. To overcome this limitation, define the data source as a parameter and use the Update Parameters In Group API call.

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please let me know. Thanks a lot!

Best Regards,    

Community Support Team _ Caiyun