Forum Discussion
ms92ita
Helper I
Helper IPower BI Api approach for dynamic report generation
Hi to all, I am developing a solution to my software that creates a dedicated Azure SQL server database for each customer and binds a dataset for each DB in DirectMode query mode with the connect...
Hi ms92ita,
Yes. You should create a dataset for each customer and then generate an embed token with the right DatasetID.
In addition, you should add the following to the config object:datasetBinding: { datasetId: "<DatasetId>" }See dynamic binding and bind datasets dynamically to a report
ms92itaHelper I
Helper IHi,
now I have created 2-3 reports from Power BI Desktop and I have already retrieved visuals and dashboards from the javascript library and token generation from the c# library in order to get the correct EmbedUrl.
Now, can I create multiple datasets dynamically (Direct Query and SQL server) with Power BI API library and then view the reports' dashboard with the correct dataset ID depending on the customer?