Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Using SQL Server
Message
From
09/05/2021 19:17:49
 
 
General information
Forum:
Microsoft Power BI
Category:
Adhoc queries
Miscellaneous
Thread ID:
01680214
Message ID:
01680264
Views:
29
>OK, there's another option for deploying to a server and allowing domain users to hit the PBI pages with a browser.
>
>Microsoft offers Power BI Report Server (On-Premise)
>
>If you are at all familiar with SQL Reporting Services, where you can deploy SSRS reports to an internal server and allow users to hit it with a browser (and without needing IIS)....Power BI Report Server works the same way. You can deploy your PBIX reports to an internal PBI report server, and users can access the reports in the same way they'd access SSRS reports.
>
>So you can create your own basic menu system to organize your reports/report folders/etc
>
>There's only one catch - it's "how to buy" Power BI Report Server, and Microsoft has made it strange.
>
>If you have SQL Server Enterprise + Software Assurance, you can get Power BI report Server for free.
>
>If you don't own those, you have to get Power BI Premium....which is not cheap. (I have heard different street prices available through Microsoft partners/vendors, but I know it's at least a few thousand a month)
>
>So clearly, Microsoft's unspoken message here is pretty clear: yes, they offer an on-premise report server option for Power BI reports that does not involve IIS or the cloud - but one way or another, it's quite pricey, and they want people to move towards the cloud.
>
>So - yes, Power BI desktop is free. But if you want to have shared pages and shared reports and access to this type of output in a browser, it's no longer free.
>
>My company uses both Power BI Report Server (for internal reports), but we also have some PBI visualizations on our customer portal that outside users can see. For that second one, we deploy the reports to the cloud (where we have a Power BI Premium license), and then we use the iFrame trick (and another .NET component called Power BI embedded) to make our PBI content available inside of our own .NET web portal pages.

The first option is a no go. That's useful to know however. Thanks So, we're looking for domain users to access it. We need to use the browser. This will be HTML only as there is no .NET development on that one. We will have a sub domain. We will build a startup HTML default sub domain page. So, we only need a way to establish a link from that page into a Power BI dashboard or report. IFrame would do or a full URL. If using that option it is not possible to have one entry point into Power BI to get all the list of available dashboards, we will simply build the list of all available dashboards and reports into the HTML page with a list with all those URLs. Is this about how you see it for the best option in such a case without having to spend thousands and use our actual licence?
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform