How to configure credentials of a report using powershell cmdlets (Using DirectQuery)

[Anonymous]

I have published report on power bi service using powershell cmdlets, but after being published to see the reports i have to provide credentials manually in power bi service.

Right now I am using this API "Data-sets - Update Data-sources In Group" to configure the connections details but in this i have to manually change credentials from power bi service.

NOTE: I'am using direct query to get data for my reports

This is the error I am getting, https://drive.google.com/file/d/1UKAqV12BUc-UF-Goyh2j1mC90IeY6EEo/view?usp=sharing

[v-diye-msft]

Hi @Anonymous 

If you've fixed the issue by your own please kindly share your solution. if the above posts help, please kindly mark it as a solution to help others find it more quickly. thanks!

[Seth_C_Bauer]

@Anonymous This thread will likely help you -> https://community.powerbi.com/t5/Developer/Possible-to-update-credentials-via-REST-API/td-p/137509/page/2