topic PowerShell scripting to tell difference between RDL and PBIX in Power BI service in Developer

PowerShell scripting to tell difference between RDL and PBIX in Power BI service

Jumpgate935 — Wed, 24 Feb 2021 15:57:20 GMT

I have a PowerShell script using the Get-PowerBIWorkspace, Get-PowerBIReport, and Export-PowerBIReport cmdlets to retrieve the report files from our Power BI service workspaces. We recently went to premium capacity, and now we have pagianted report content some of our workspaces. In our case, the RDL and PBIX files in the workspace are named with the same name.

My current export script is finding the two items named the same (one paginated report and the other a Power BI report), but it doesn't handle identification of the file I am looking at as RDL or PBIX content. (My script to this point has assumed that it would only see PBIX files and writes the files out with that extension.) The effect of my script exporting the workspace is that the first extraction is overwritten by the second, since I am just reading out the exported file contents and appending the PBIX file extension to it.

I didn't see anyway in the return data from the PowerShell cmdlets I'm using to determine what kind of report content I am accessing - RDL or PBIX. Is there a type value or some value I can evaluate to filter my powershell command to find only the RDL content?

Re: PowerShell scripting to tell difference between RDL and PBIX in Power BI service

Anonymous — Fri, 26 Feb 2021 07:39:08 GMT

Hi @Jumpgate935 ,

According to the syntax of cmdlets Get-PowerBIReport, I did not find any parameter to identify the report type. Please check this documentation for details. You can raise a new idea and add your comments there to make this feature coming sooner.

Get-PowerBIReport [-Scope <PowerBIUserScope>] [-Filter <String>] [-First <Int32>] [-Skip <Int32>] [-WorkspaceId <Guid>] [<CommonParameters>]

Best Regards

Re: PowerShell scripting to tell difference between RDL and PBIX in Power BI service

Jumpgate935 — Tue, 02 Mar 2021 13:26:34 GMT

Thank you for your input - I've added a Power BI Idea for that enhancement here: Microsoft Idea · Extend the PowerShell scripts Get-PowerBIReport and Export-PowerBIReport to identify RDL vs PBIX content . Vote it up!

So given that I can't identify the file with an attribute in those PowerShell scripts, does anyone have a tidy way in PowerShell to examine the file I've downloaded to deternine if it is a PBIX or RDL file? I'm assuming the content of the files would tell me if I knew what I was looking for in them and the best way to script that examination.