How to create dynamic report Power BI programatically?

[Krunalbpatel]

Hi,

I want to create dynamic Power BI report programmatically. How Can I  create Dynamic report in Power BI? 

Actually I want to create 1 pbix (Power BI Report) and publish the reprot to the Power BI account. Now I want that there are different users in the Application. Based on logged in user I want to generate different reprots for all the users. I want that for every user there are different report generated. Dataset of the report is different for different user. 

Is there a way that I can import pbix file and create new dataset and generate report from the newly imported pbix file and dataset for that file will be used that is newly created?

Thanks & Regards

Krunal Patel

[Eric_Zhang]

---

@Krunalbpatel wrote:

Hi,

I want to create dynamic Power BI report programmatically. How Can I  create Dynamic report in Power BI? 

Actually I want to create 1 pbix (Power BI Report) and publish the reprot to the Power BI account. Now I want that there are different users in the Application. Based on logged in user I want to generate different reprots for all the users. I want that for every user there are different report generated. Dataset of the report is different for different user. 

Is there a way that I can import pbix file and create new dataset and generate report from the newly imported pbix file and dataset for that file will be used that is newly created?

Thanks & Regards

Krunal Patel

---

@Krunalbpatel

At this moment, you can't create report programatically. Not sure why you'd like different report for different users, if for scecurity purpose, say people can only see their own data, you can check Row Level Security.

[Krunalbpatel]

Hi @Eric_Zhang,

Thanks for your reply.

I know about the Row Level Security. But my requirement will not be satisfied with that. I have to generate report with the Google Analytical data. So I can not get All the users data in 1 dataset. So In that case I have to create manual report for every User. So I want that I can create dynamic dataset and assign to the pbix file. 

Thanks

[Eric_Zhang]

@Krunalbpatel

Well, I'm afraid it is not possible at this moment. You can check this idea Power BI Designer API and vote it up. The Power BI Designer API may allow you to change the dataset in a pbix programatically.