automation
5 Topics
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.Solved3.3KViews0likes3Comments
Export Report Page from Report Server to PDF with Single Click
Are there any ways to automate the exporting of PDFs from a PowerBI report page from the Report Server, with user-selected filters and what not to a saved folder that doesn't require dedicated capacity and is super simple and quick? I have tried building a button within each report page itself that triggers a PowerAutomate automation, but without dedicated capacity nothing works. Thanks!Solved561Views0likes1Comment
Power BI Report Server Dashboard Usage Stats
I'm interested in learning how to generate usage statistics, such as user logins, dashboard visit counts, and least-viewed screens. Could anyone please guide me through the process of creating an execution log or utilizing existing data to develop a Power BI report for publication on the Report Server web portal? Additionally, is it possible to automate the generation of these usage reports?1.1KViews1like2Comments
Automated PDF Generation
Hello, We need to generate some multi-page PDF's each month and we have a Power BI Report Builder report that does what we want. We were able to automate the export using a Premium license and Power Automate. But then when we tried to loop it to do what we need it gave an error stating that PPU accounts can only perform an export once every 5 minutes. Apparently we need to change to a capacity license for $5,000 per month (!!!!!) to accomplish this task? It seems ubsurd that we would need to go from $20/mo to $5k/mo to export some reports. Does anyone know of a reasonable way to dump some reports out to PDF automatically in a performant and cost effective way using the Microsoft platform? Thanks, ChrisSolved4KViews0likes8Comments
Refresh Failure Alert for Multiple Dashboards
Hello Team, I took charge of a BI engineering function having around 400 dashboards. I noted that for the scheduled refresh failures, the emails were going to the individual folks causing lot of bottlenecks in terms of operations. Instead of adding the email group(security enabled email group), is there a way to put this across all dashboards in one go. It will save the team their previous time and will also get an edge in creating a utlity to be used in future. Thanks in advance!! Chandan JhaSolved944Views0likes2Comments