Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

One Dataset and Report for different Customers and different Gateways

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

dataflow
Need Help

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Anonymous 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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

      • Greg_Deckler's avatar
        Greg_Deckler
        Icon for Community Champion rankCommunity Champion
        4 years ago

        Anonymous So, you are using DirectQuery then versus Import mode?