Hi Folks,
I am doing some research on Power BI to check feasibilty whether we can utilize Power BI in our project or not.
We have a Web application that we sell to multiple customer (each customer do have it hosted on their premises and do have their own DB containing their data). Now, along with this Web application, we also want to deliver them few standard charts that will show up according to their data. We want to utilize Power BI for this. Additionally, we don't want our customers to create that charts on their own because they might not have in-depth knowledge to do it. Our developers will create the charts (definition) and will deliver to customers.
But the first challange we see is, PBIX files do contain data. Meaning, one PBIX file can't be delivered to multiple customers. Also, we can't create separate PBIX for each customers because we have hundreds of customer. What we want is, our developers create few Power BI Charts once, and we deliever them to customers and then they point them to their DB and the chart should show up.
In this case, we came to know about Direct Query connection mode, which doesn't actually contain data in it. But, then if we create charts using Direct Query as well, then after delivering them to customer, then will have to point it to their DB manually by opening it in PBI Desktop. Because, connection string can't be modified using any APIs programmatically. Our customers won't even prefer that because we have aroudn 50 types of charts.
We then came to know about Power BI Template concept. But again, we are seeing that, No APIs (neither the APIs of Power BI Service nor the REST APIs of Power BI Report Server) support playing with Power BI Template. We want a solution wherein we get things automated using APIs programmatically.
Can someone guide us on this? Or am I missing any aspect of Power BI Template? like Do any APIs support uploading/modifying Power BI Templates (.pbit file) on Power BI Online or Power BI Report Server ?
