topic Change data source connection strings in Power BI reports with PowerShell in Report Server

Change data source connection strings in Power BI reports with PowerShell

castrom — Fri, 04 Oct 2024 10:58:24 GMT

Hi,

I'm trying to automate PowerBI reports deployment using Azure Pipelines and PowerShell.

I am able to connect to PowerBI using Connect-PowerBIServiceAccount and a service principal.

I also can list workspaces and existing reports.

My next task is to change the data source connections. I have been following this MS documentation https://learn.microsoft.com/en-us/power-bi/report-server/connect-data-source-apis but when I try the following:

# Get report parameters

$parameters = Get-RsRestItemDataModelParameters '/Infusion_Model_Auto'

I get this error:

Failed to create a new session to http://localhost/reports/api/v2.0/me :

| The cmdlet cannot protect plain text secrets sent over unencrypted

| connections. To suppress this warning and send plain text secrets over

| unencrypted networks, reissue the command specifying the

| AllowUnencryptedAuthentication parameter.

I'm not sure what's going on, since I already have an active connection.

Thanks for any help.

Re: Change data source connection strings in Power BI reports with PowerShell

lbendlin — Fri, 04 Oct 2024 12:22:43 GMT

Please confirm if you indeed are attempting to do this for Power BI Report Server.

Re: Change data source connection strings in Power BI reports with PowerShell

castrom — Fri, 04 Oct 2024 12:48:23 GMT

Hi lbendlin ,

I think I just realised that the instructions here are for a PowerBI on prem setup.
We are using the PowerBI app in Azure, so I don't think we have a PowerBI Reports Server.
I will try another approach now, by using the PowerBI Rest APIs.

Thanks for coming back to me though.

Re: Change data source connection strings in Power BI reports with PowerShell

Anonymous — Fri, 11 Oct 2024 08:50:01 GMT

Hi, lbendlin .Thanks for your concern about this issue.

Your answer is excellent!
And I would like to share some additional solutions below.
Hello,castrom .I am glad to help you.
It looks like you are trying to implement a report data source change on Power BI Service (not Report Server)
Hopefully the following API link will help you out
URL:
Gateways - Update Datasource - REST API (Power BI Power BI REST APIs) | Microsoft Learn

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.

Best Regards,

Carson Jian,

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