topic Re: Publishing Power BI Report files to On Prime Power BI Report Server using command line utility in Report Server

Publishing Power BI Report files to On Prime Power BI Report Server using command line utility

elitekrishnan — Thu, 22 Mar 2018 11:10:20 GMT

Hi,

I need to upload my Power BI Report files to Power BI Report Server. I have tried with PowerShell Utility ReportingServicesTools for SSRS Report and able to publish the SSRS reports in Power BI Report Server, but the same code is not working for PBIX files. I am able to publish using Power BI Desktop (October 2017) and able to upload through Power BI Reporting portal.

Is there any option available to upload the Power BI Report files(PBIX) to On Prime Power BI Report Server using

command line utility like Rs.exe for SSRS? , have tried with RSPowerBI.Exe, not sure about the parameter list.
or using PowerShell command?

Thanks,

Navaneethakrishnan Thangaraj

Re: Publishing Power BI Report files to On Prime Power BI Report Server using command line utility

krisztb — Sat, 24 Mar 2018 01:00:04 GMT

Hi Navaneethakrishnan,

Try the Write-RsRestCatalogItem PowerShell command (https://github.com/Microsoft/ReportingServicesTools/blob/master/ReportingServicesTools/Functions/CatalogItems/Rest/Write-RsRestCatalogItem.ps1)

Hope this helps,

Krisztian

Re: Publishing Power BI Report files to On Prime Power BI Report Server using command line utility

elitekrishnan — Sun, 25 Mar 2018 17:34:06 GMT

Hi Krisztian,

Thanks for your help. It is working.

Re: Publishing Power BI Report files to On Prime Power BI Report Server using command line utility

Plantje — Mon, 16 Apr 2018 16:34:27 GMT

Hi,

Could you give any additional pointers? I am trying to do the same thing and I have tried dozens of shell commands by now. Most of them don't return an error, but none of them results in the report being published to the report server. What am I doing wrong? Is there some sort of logging?

This is part of what I have tried so far:

PS F:\> ./Write-RsCatalogItem -ReportServerUri 'http://localhost:8080/reports' -Path f:\test.pbix
PS F:\> ./Write-RsCatalogItem -ReportServerUri 'http://localhost/reports' -Path f:\test.pbix
PS F:\> ./Write-RsCatalogItem -ReportServerUri 'http://localhost/reports' -Path f:\test.pbix -rsfolder /Archief
PS F:\> ./Write-RsCatalogItem -ReportServerUri 'http://localhost:8080/reports' -Path f:\test.pbix -rsfolder /Archief
PS F:\> ./Write-RsCatalogItem -ReportServerUri "http://localhost:8080/reports" -Path f:\test.pbix -rsfolder /Archief
PS F:\> ./Write-RsCatalogItem -ReportServerUri "http://localhost:80/reports" -Path f:\test.pbix -rsfolder /Archief
PS F:\> ./Write-RsRestCatalogItem -ReportServerUri "http://localhost:80/reports" -Path f:\test.pbix -rsfolder /Archief
PS F:\> ./Write-RsRestCatalogItem -ReportServerUri "http://localhost/reports" -Path f:\test.pbix -rsfolder /Archief
PS F:\> ./Write-RsRestCatalogItem -ReportServerUri "http://bidb01a/reports" -Path f:\test.pbix -rsfolder /Archief
PS F:\> ./Write-RsRestCatalogItem -ReportPortalUri "http://bidb01a/reports" -Path f:\test.pbix -rsfolder /Archief
PS F:\> ./Write-RsRestCatalogItem -ReportPortalUri "http://localhost/reports" -Path f:\test.pbix -rsfolder /Archief
PS F:\> ./Write-RsRestCatalogItem -ReportPortalUri "http://localhost/reports" -Path f:\test.pbix
PS F:\> ./Write-RsRestCatalogItem -Path f:\test.pbix
PS F:\> ./Write-RsRestCatalogItem -ReportPortalUri 'http://bidb01a:8080/Reports' -Path f:\test.pbix
PS F:\> ./Write-RsRestCatalogItem -ReportPortalUri 'http://bidb01a:8080/Reports' -Path f:\test.pbix
PS F:\> ./Write-RsRestCatalogItem -ReportPortalUri 'http://bidb01a:8080/Reports' -Path 'f:\test.pbix'
PS F:\> ./Write-RsRestCatalogItem -ReportPortalUri 'http://localhost:8080/Reports' -Path 'f:\test.pbix'
PS F:\> ./Write-RsRestCatalogItem -ReportPortalUri 'http://localhost/Reports' -Path 'f:\test.pbix'
PS F:\> '

Thanks!

Re: Publishing Power BI Report files to On Prime Power BI Report Server using command line utility

Anonymous — Mon, 16 Apr 2018 21:24:46 GMT

http://byobi.com/2018/04/programmatically-deploy-power-bi-reports-to-power-bi-report-server/

Try creating a session to your report server like the link shows. I'll replace some variables in the code below.

X = report server uri
Y = path to file
Z = folder you're writing to. Be sure to write a "/" in front of it

$session = New-RsRestSession -ReportPortalUri X

Write-RsRestCatalogItem -WebSession $session -Path Y -RsFolder Z

Let me know if it works.

Re: Publishing Power BI Report files to On Prime Power BI Report Server using command line utility

Plantje — Tue, 17 Apr 2018 09:41:50 GMT

Thank you for your reply.

I looked at the documentation under the link. Seems straight forward. I am still struggeling somewhat. First of all: our development machine is a Windows Server 2012, whereas the A and P machines are Windows Server 2016.

So, on the development server I first needed to run "PackageManagement_x64.msi" in order to be able to use "Install-Module" in the first place.

Next up, unfortunately, none of our servers are connected to the internet, so there is no way to have the server download "nuget" automatically as soon as it is needed (which is right after running the "Install-Module" command I guess).

Tried a "solution" that I found to copy the file Microsoft.PackageManagement.NuGetProvider.dll from a Windows 10 machine that does have internet. But then I get the next error message.

PS F:\powershell\reportingservicestools> Install-Module ReportingServicesTools

PackageManagement\Install-Package : No match was found for the specified search criteria and module name 'ReportingServ

icesTools'.

At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\PSModule.psm1:1417 char:21

+ $null = PackageManagement\Install-Package @PSBoundParameters

+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

+ CategoryInfo : ObjectNotFound: (Microsoft.Power....InstallPackage:InstallPackage) [Install-Package], Ex

ception

+ FullyQualifiedErrorId : NoMatchFoundForCriteria,Microsoft.PowerShell.PackageManagement.Cmdlets.InstallPackage

This is getting pretty frustrating... what happened to good old command line options using the command prompt? :(

Re: Publishing Power BI Report files to On Prime Power BI Report Server using command line utility

elitekrishnan — Tue, 17 Apr 2018 11:52:51 GMT

Hi,

In this post, he mentioned about datasource connection string update, but this is not working, I have posted in separate thread.

http://community.powerbi.com/t5/Report-Server/Power-BI-Reports-Connection-String-change-on-Power-BI-Report/m-p/391343

As per Jon-Heide reply, as of now connection string update is not supporting for Power BI Reports after publish.

Kindly let me know if this is working for you.

Thanks,

Navaneethakrishnan Thangaraj

Re: Publishing Power BI Report files to On Prime Power BI Report Server using command line utility

elitekrishnan — Tue, 17 Apr 2018 11:56:29 GMT

Hi Plantje,

I had same problem to download PowerShell modules form internet. For alternate , you can download the PS module and extract it to your windows server and import it in the begining of your script file, then it will work.

Import-Module -Name F:\PowerShell\ReportingServicesTools

Thanks,

Navaneethakrishnan Thangaraj

Re: Publishing Power BI Report files to On Prime Power BI Report Server using command line utility

Plantje — Tue, 17 Apr 2018 12:05:25 GMT

Great! This seems to work!

So, rather than using "install-module" I can also use "Import-Module" all else is the same as it seems.

Thank you VERY VERY much!

Re: Publishing Power BI Report files to On Prime Power BI Report Server using command line utility

sprasad — Fri, 27 Jul 2018 09:41:55 GMT

Hi,

Once the report is uploaded on to the Report Server I wanted to input the SQL database credentials. What would be the commandline syntax to use this utility?

Thanks

Re: Publishing Power BI Report files to On Prime Power BI Report Server using command line utility

Plantje — Tue, 31 Jul 2018 05:35:04 GMT

That's done through the data source update, mentioned earlier in the thread. In order to do that you have to put the user name and password for the data source in the power shell script