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.
Hi everyone,
I'm pretty new in Power BI (11 Months)
We've developed an ERP-System with a on-Premise Database (Firebird) for our customers.
Now we've also delevoleped a fully fledged Power BI Finance Report, (for our own purposes) for this Database, with all its Relations and Attributes.
This Dataset is published on our Power BI Service Workspace and it is connected to our Local Database as ODBC-Connection with the Power BI On-Premise Gateway.
Now we want to provide our Solution as an App for our Customers as for their local Database and configured on-Premise Gateway, without providem them the full access of the Dataset and Report (only interacting and view of the report).
Which typ of license(s) are needed (we've used Pro so far) and what are the necessary steps to publish our solution for our customers with their data and obviously not our owns.
(If Possible) And if we want to commit changes to our Report, to only update one Dataset-Solution for all Customers
Thanks
@SC-THOLD-IT OK, so I believe the answer to that is to build a third party app for AppSource.
Create a Power BI app offer on Microsoft AppSource (Azure Marketplace) | Microsoft Learn
@SC-THOLD-IT Sorry, I'm not entirely following. You have an ERP with an on-premises database. Is there just one instance of that or does each customer have their own instance that they run? If it is the former, then you could implement RLS and 1 option would be to use B2B sharing (they would need a Pro license). Alternatively you could give then a login in your AAD and provide the license. Another option would be to use Premium and then they would not need a license. And then the other option would be Power BI Embedded, again, no individual license required. This might help: Power BI Licensing in Pictures - Updated! - Microsoft Power BI Community
@Greg_Deckler
each customer using our ERP-System has its own (Firebird) On-Premise Database instance
Let me add this:
- How can we change the Data-Source (from a different Data Gateway) depending on who is viewing the Mainreport
@SC-THOLD-IT So, you are using DirectQuery then versus Import mode?
@Greg_Deckler
No, its in Import Mode.
1. Imported the Data from an ODBC-Source (There is no other way)
2. I've build a Report and published it on Power BI Service
3. Configured a Gateway
4. Pointed the Dataset at that Gateway as datasource
Now, what i want:
1. other parties want the same Report (Completly different Domain, they have nothing to do with us)
2. We dont want third parties have FULL acces to the Solution, only Read-access
3. And only with their datasource (different Gateway)
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.