topic change Datasource settings. in Developer

change Datasource settings.

Anonymous — Sat, 25 Jun 2022 10:19:20 GMT

We are using Snowflake source for PowerBI. After completion of my development i have published into powerbi service.

How can we change the snowflake WH after deploying? When i am tryoing to change in service,

When i am trying to change connection details, its greyed and disbled to edit. Can you please suggest here to proceed..

Re: change Datasource settings.

Seanan — Mon, 27 Jun 2022 01:12:58 GMT

Hi @Anonymous

I'm not familiar with snowflake myself but I did manage to find a similar post that seems like it will be able to help resolve your issue. Please find the post here.

Re: change Datasource settings.

v-chenwuz-msft — Tue, 28 Jun 2022 10:12:03 GMT

Hi @Anonymous ,

You can use XMLA endpoint to change the data source in power bi service. For more details please refer this article.

Using XMLA endpoints to change data sources in a Power BI dataset | Microsoft Power BI Blog | Microsoft Power BI

Maybe you can try use Dynamic M query parameters in Power BI, so that you can use the parameter in pwoer bi serivce to change the data source.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.