Forum Discussion
Licensing Power BI on prem server in mixed Standard and Ent SQL environment
After creating another test PBIRS server with basic configuration and getting the same result, I gave up and contacted MS support.
While we were going over my configuration with MS support tech and making changes here and there, all of a sudden, I was able to upload the PBIX report.
I took my time and tried to recreate the steps on two of my other servers, prod that did not work and dev that did work. I was able to fix my prod PBIRS server and to break and fix my dev server. Here is what I found.
When I create an SSRS server, I usually remove HTTP or port 80 Web Portal URL (/Reports). I do not want anyone using non-secure access. When I configured PBIRS, I did the same. It turns out, publishing PBI reports requires HTTP access to exist, even though you upload or Save As to HTTPS URL. Not sure why, but that is it.
Now, here is the sequence if you need to recover from the same issue I had: add HTTP (port 80) to Web Portal URL reservation, save, remove HTTPS, save. Now test if you can upload a PBIX report, should work. Now add HTTPS back, should also work. Just adding HTTP when HTTPS already exists does not work.
Turns out, nothing to do with licensing.
Enjoy!
Memorable MemberHi Igorek_2000 ,
for the Power BI Report Server you need also a Power BI Pro Licence to publish reports (but this is not the problem - because this can't be tracked by anyone - this is more a matter of trust)
Have you checked the configuraton manager and checked the configurations?
And please be sure that the Desktop Client has the same version like the Report Server :). That is really important!
Here are some helpful links:
https://radacad.com/power-bi-report-server-power-bi-in-on-premises-world
https://www.youtube.com/watch?v=zacaEb9A4F0
Best,
Kathrin
If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!
Hi KBO
Thanks for a quick reply!
Understood about Power BI Pro licensing.
I compared both my dev and production environments, both the same version, dev is PBIRS Developer, production is PBIRS SQL Ent with SA. Both have the same configuration, only URLs are different.
Dev report DB is hosted on Dev edition of SQL, production is hosted on SQL Std. Both use report DB converted from the same SSRS report DB.
Both PBIRS servers are May 2020, PBI desktop RS is May 2020 also.
I can upload PBIX file to the dev environment, but on prod, I get the following message with the same file:
An error has occurred.
There was an error uploading your .pbix file. Verify that the file has not been corrupted and that the file extension matches the format of the file.
- KBO
Hi Igorek_2000 ,
how do you upload the report?
If you upload it via Desktop Client you should get an better information, like "Server cant be reach" or something. If you uploaded it directly over the Power BI Report Server the Error Message is not really helpful ;).
Best,
Kathrin
When I use Save As on PBI Desktop for RS and choose Power BI Report Server, I type my prod server URL and I'm able to choose a folder on PBIRS where I want to save PBI report. So I'm connected to my server. But when I click OK, I get below
Same report from same client, I can save to Dev server without a problem.
I still think it has something to do with report DB not been on SQL Ent or something similar.
Thank you.