I am facing an issue and hoping you would be able to help me with it.
We recently upgraded to the October 31, 2017 release of Power BI Report Server. That upgrade was on top of the June 2017 version of the server.
We also installed the October 31, 2017 version of PBI Desktop and upgraded one of the PBI reports that was initially created using an older version of PBI Desktop.
This report, after published to the PBI Server, doesn't render when we try accessing it from the server. The log files have the below error -
2017-11-15 17:42:02.3848|ERROR|249|GetPbixReportMetadataAsync RSPortal returned error code Forbidden for catalogItem c34d0b63-8a48-41ae-9752-69e37f03d48f. Check Portal logs.| RequestID = 93f4c176-c454-c732-c706-d83f52a7c9ba ClientSessionID = 1cfaf8a2-527b-f040-b50a-2a2ba9d70732
We tried with a Live Connection to an Oracle database, a data-import version and also a report without any connections but just text component on it - none of these reports rendered on the server - get the same error in all the cases.
Any inputs from the community here would be appreciated!
Looking forward to some helpful comments; Thanks in advance!
It seems that all reports deployed to the Power BI report server October version don't work, right?
Please click "..." on top right corner of the report, click Manage-> Properties-> Edit in Power BI desktop, check if the report can display fine in desktop.
Thanks for your response!
I tried your suggestion and even if I have Power BI Desktop October 2017 version installed on my machine, I got a pop-up saying "Syntax: PBIDesktop.exe [filename.pbix]" and nothing happened after that i.e. PBI Desktop didn't open.
I have attached the pop-up for your reference -
Some more information on this issue:
We have checked the firewall settings - that is not causing the problem. We are able to access the SSRS reports published to the same PBI Report Server without any issues using the hostname URL.
Any help on this issue would be appreciated!
Did you manage to resolve this issue? We are getting the same issue on a scale-out install. After a restart, the reports work fine for about 10 minutes, then we just get a blank screen under the tool bars.
The only error is in the RSPowerBI Log file with:
GetPbixReportMetadataAsync RSPortal returned error code Forbidden for catalogItem
I had the same problem. Setting the ReportServerUrl element in the config file as described on the following page then restarting the windows service solved the problem.
This step really needs documenting officially. Without it the On-Prem Server basically isn't usable in scale-out confirguation.