Forum Discussion

castrom's avatar
castrom
Frequent Visitor
1 year ago
Solved

Change data source connection strings in Power BI reports with PowerShell

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.
automation
Azure
PowerShell
ReportingServicesTools
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.




3 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago

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

  • castrom's avatar
    castrom
    Frequent Visitor
    1 year ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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.