Issue in Importing Power BI Report and Refreshing with changing WebApi URL lose credential

[BimalK]

Hi 

I come across an issue after an import report from one workspace to another and change  WebApi Url using .NET  PowerBI SDK

and refresh the report and it complains credential error.

The following is the approach that we would like to implement.

1. One main workspace with multiple reports -> 2. other workspaces cloning from the main workspace -> 3. update individual report data source via updating data source URL-> 4. Refresh report data set.

From step number 2 we implement with PowerBI.Net SDK.

At step number 3 we update the data source URL to a new s3 pre-signed URL or any public accessible URL via the setting parameter (ConnectionUrl), No error return up to this point. However, when we try to refresh dataset (Step 4) we receive the missing credential error. To solve this issue, we have to open PowerBi Online  and click on the 'sign in' button, although the credential type is set to 'anonymous'. 

After the sign in button click on the imported report dataset, it starts refresh.

We can't find a way to trigger this programmatically, could you advise how to solve this issue? we would like to trigger the update data source URL and successfully refresh it without accessing the PowerBI Online Service

Best Regards

Assetic Development Team

[v-qiuyu-msft]

Hi @BimalK, 

Based on my research, if the dataset doesn't use on-premises data gateway, we are not able to use Power BI rest API to set data source credential. 

Currently, Power BI only provide API for us to change credentail for data source created under Manage Gateways, see: https://docs.microsoft.com/en-us/rest/api/power-bi/gateways/updatedatasource

For your requirement, you can vote this same idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/18535039-update-credentials-of-da...

Best Regards,
Qiuyun Yu