I finally did it. I created a function I’ve been wanting to be able to use for *years*. Test-RsRestItemDataSource is here.
I can’t tell you how many times I’ve started to work on a report I was told was working, only to find the connection info was invalid. This wastes valuable time, especially when you’ve already made changes to the report.
Other times, I’ve been asked to figure out why a bunch of subscriptions weren’t working, only to find out it was a simple connection issue. I’ve always wanted a simple PowerShell command to check the credentials of a bunch of reports before I touch anything.
Turns out, it wasn’t that hard to build at all. I only wish I had built it years ago.
This command will check every credential within your report, and will return the success/failure of each connection separately. I have built this command to work with both Power BI reports & Paginated reports on Power BI Report Server. I used the REST API so these commands are available on PowerShell 7.
While I was working on the ReportingServicesTools module I added two more commands as well. I added Get-RsRestCacheRefreshPlanHistory for checking the success/failure of last few refreshes of a Power BI report. I built this command to help me find out when a report refresh stopped working.
I also built Get-RsRestItemAccessPolicy which is basically a re-creation of the Get-RsCatalogItemRole command, but using the REST API instead of the SOAP API. I have more work I plan to do to create [ Grant | Revoke ] commands. But first I need to learn how to add & subtract ( INSERT / DELETE ) lines of JSON from PowerShell. 😀
About the Author:
I am a Senior SQL Server Architect with over 15 years experience in architecture, business intelligence, development, and performance tuning of SQL Server. Currently, I do a lot of data visualization work. I ❤ Power BI.
Check out my blog here.
Nelson, A. (2021). Added another 3 new PowerShell functions for reports on Power BI Report Server. Aailable at: https://sqlvariant.com/2021/02/added-another-3-new-powershell-functions-for-reports-on-power-bi-report-server/ [Accessed: 2nd March 2021].
Find more great Power Platform content here.