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 ,
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.
- KBO
Hi Igorek_2000 ,
I think there is defenetly a problem with connecting to the DB :). Check the permissions from the User you choose in the configuration manager. Check If the User have the same permissions as on the other Server which work.
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!I'm admin on both servers, DB is fine since I can publish paginated reports.
Thank you
- d_gosbell
Super User
So technically the database does not need to be on an Enterprise edition and it does not need to be on the same physical server. The error dialog is not giving us much to go so you should check the log files. These are typicallystored in "C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles" by default.
Each sub-component of PBIRS generates it's own logs. You will probably want to check both the RSPortal_* log files and maybe the RSPowerBI_* logs. I suggest you reproduce this issue, wait 5-10 seconds then open up the latest copy of both these log files and scoll to the end and then start browsing up looking for error messages.
So while technically your configuration should work, from a licensing perspective PBIRS itself should be running on cores that are covered by an Enterprise Edition of SQL Server (with SA). It's fine to have the ReportServer database hosted on another instance with different licensing, but PBIRS itself needs to be on the enterprise licensed cores.
