I have created a PBIX that used direct query to SQL Azure DB. I initially created this report in development environment that points to my development DB.

For production purpose, I programatically upload this report to a group in Power BI. Likewise for other reports. Then I try to programatically update the data source along with credentials using PowerBI API. But it fails. It updates the data source (DB server and catalog), but not the credentials.

Below is my sample code that updates the data source connection string:
foreach( var ds in client.Datasets.GetDatasetsInGroup(grp.Id).Value)
client.Datasets.SetAllDatasetConnectionsInGroup(grp.Id,ds.Id , new ConnectionDetails(ConnectionString));

Am I doing it the right way.

Thank You!!!

I didn't find the right solution from the Internet.
References
http://community.powerbi.com/t5/Developer/Unable-to-update-data-source-credentials-using-PowerBI-API/td-p/298585
Corporate Whiteboard Animation

Отредактировано Williamhawk (2017-11-27 10:48:56)