PowerBi reports in PHP-based service

[Caiss]

Hi all,

One of our customers wants to improve his existing PHP-based web app and give his clients possibility to track business data with PowerBI. My task is to evaluate if there's even possible to do that, and what'd be the cost of introducing PowerBI.

After quick review of Developer doc I got more questions than answer - maybe because Microsoft tools are not the ones, that I use on daily basis. To say the truth, I found existing doc somewhat confusing. So please indulge me, if the quetions below are too naive.

Our customer would like to have an app, where logged web user can create, edit and view individual reports regarding his own business. Something like on https://microsoft.github.io/PowerBI-JavaScript/demo/v2-demo/index.html. Users wouldn't have any extra PowerBI accounts (if possible).

The questions are:

1. Is it even possible to create PHP app, where web user can compose his own PowerBI report?

2. Is it possible for user not only to view, but also to compose his own report in web app, if he doesn't have PowerBI account?

3, Is it possible to give the user an access only to portion of data, that is related to his business? (so he couldn't see any sensitive business information of other users).

Thanks in advance for any answer.

[v-jiascu-msft · Accepted solution]

Hi @Caiss,

Above all, I would suggest you download the PowerBI-JavaScript and try it yourself. We can create reports on the online demo but we can't save them due to it's a public demo.

1. It's possible. APIs are general interfaces, so we can use them in many programming languages. There is also a Create mode API. Please refer to power-bi/embedtoken/reports_generatetokenforcreateingroup

2. Yes, they can create reports. Actually, this is the App Owns Data mode. One master count act as a Power BI user.

3. Yes, RLS would be the solution. I would suggest creating some App workspaces. So the dataset could be separated and the reports created by the users won't crowd together.

Best Regards,

Dale