Hello,
I'm working at a company where we sell PowerBI dashboards for customers to get an insight in their usage/data. The flow is as follows:
- Data comes into Azure Synapse
- Pipeline is created to transform the data
- Tables in the Lake Database are updated
- PowerBI files auto refresh some time after the pipeline triggers, the timings aren't connected, just some hours after the other
- Customer sees their updated report, which is embedded on their personal page on our website.
Since we are scaling up with the number of PowerBI reports that we are selling, I am looking for a way to incorporate the creation of a PowerBI file (given a report template) so that once the pipeline is created, we do not have to manually create a new file for each new customer, or when something changes in the template, we'd have to change all the files.
In short, is there a way to create an embedded powerBI report, given a PowerBI report template, tables stored in Azure Lake Database, such that it can be added at the end of a pipeline?
Many thanks for any response!
UPDATE: We are going to work with Flask, and a package called "pbirest", which is a wrapper for the PowerBI Rest API. It seems like this would fit our needs, however I will report back once I know more, for future people having this issue.
