Custom reports from query

[Uranium2]

Hello,

I never used Power BI before, I tried to find documentation on what I'm trying to achieve.

For the moment I have an App, the device sends data to an Azure SQL server. Then I made a WEB API in c# to create custom charts in Javascript. The WEB API Query the SQL server, makes a graph on a web page and send it to the device.

I'm trying to find something more stable, easy to maintain, so Power Bi Embedded looked nice, but I need some more information.

I see that we can Pushing reports to web from Power Bi, great! Sounds what I need. I just need to insert the emdedded code to the right place. But, how can I make custom reports for every users? Can the App Query Power Bi to create a new Report for one particular user and then load only this report?

[Eric_Zhang]

---

@Uranium2 wrote:

Hello,

I never used Power BI before, I tried to find documentation on what I'm trying to achieve.

For the moment I have an App, the device sends data to an Azure SQL server. Then I made a WEB API in c# to create custom charts in Javascript. The WEB API Query the SQL server, makes a graph on a web page and send it to the device.

I'm trying to find something more stable, easy to maintain, so Power Bi Embedded looked nice, but I need some more information.

I see that we can Pushing reports to web from Power Bi, great! Sounds what I need. I just need to insert the emdedded code to the right place. But, how can I make custom reports for every users? Can the App Query Power Bi to create a new Report for one particular user and then load only this report?

---

@Uranium2

At this moment, there's no Power BI Designer API, so it is not possible to generate a pbix file in a programmable way. If the users have the exactly same database tables and report, then you can reference this link.

Alternatively, if the data of the users is in the same Azure SQL database, then you may just apply Row level security. 

[Uranium2]

Hello,

I never used Power BI before, I tried to find documentation on what I'm trying to achieve.

For the moment I have an App, the device sends data to an Azure SQL server. Then I made a WEB API in c# to create custom charts in Javascript. The WEB API Query the SQL server, makes a graph on a web page and send it to the device.

I'm trying to find something more stable, easy to maintain, so Power Bi Embedded looked nice, but I need some more information.

I see that we can Publish reports to web from Power Bi, great! Sounds what I need. I just need to insert the emdedded code to the right place. But, how can I make custom reports for every users? Can the App Query Power Bi to create a new Report for one particular user and then load only this report?