Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear Community!
I am evaluating Power BI Report Server as an alternative to IBM Cognos, which we are using in our company. I've read the forum entries and documentations, but I could not find the answer, if we really could use PBRS.
We are using
I successfully installed PBRS on the App server, but it is not accessible from outside. If I install PBRS on the web server, it will be accessible from the internet, but will have no (direct) database connection.
I also tried to make use of the On-premises data gateway, but it wants my Email-address. Why?
So my questions are:
Best regards,
Gery
Hi @gerald_bauer,
For Power BI Report Server installation, please have a look at: Hardware and software requirements for installing Power BI Report Server
For Row Level security, it is not supported in the October version of the Power BI Report Server, you can implement row level security with windows authentication all the way throught the database for example https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security
On Premise data gateway is used for Power BI service. You can configure it on PBIRS.
Regards,
Yuliana Gu
Thank you for your response!
As October version does not support RLS ,I will implement it on database level.
I read the requirements, but couldn't find a hint for a setup with a perimeter network (no connection between web server and database server).
For the gateway: Your wrote "You can configure it on PBIRS". So you mean, it is possible to use the on premise data gateway together with PBIRS on premise?
From this discussion question around the PBI custom connectors, we were told that the Power BI Report Server does not support the enterprise gateway at this point in time.
https://github.com/Microsoft/DataConnectors/issues/131
Senturus has a custom connector that will connect Cognos models & cubes over to Power BI to use as a data source. This will let you leverage all the curated data, user permissions, and audit trails already in place in cognos and the powerful PBI visualizations. You can deploy to Power BI Service and leverage the enterprise gateway + custom connector to reach back inside your network securely for this data. For more info or a demo, visit:
https://www.senturus.com/products/analytics-connector/cognos-powerbi/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
9 | |
5 | |
3 | |
3 |