Forum Discussion
Automating Publishing
Hi both,
Thanks for the responses. I believe my question was misleading with the term 'Automate', I don't think gateway refresh is the solution I am looking for however I maybe wrong.
I will explain my problem in greater detail. I have a master dashboard that contains all of the data for 100 locations, I need individual dashboards for each location (For each location I use a power query parameter to filter the data correctly). I've created all 100 dashboards, published them, and set up schedule refresh as the data is updated monthly. However, now my client has asked me to add an additional page to the report and edit some of the other measures. I don't want to edit all 100 dashboards. So far I have edited the master file to meet my client's requirements and duplicated that file using Python code to create the 100 dashboards. My question is how can publish all 100 dashboards without manually opening the pbix file and clicking publish?
- I couldn't see the functionally of publishing from a local machine using PowerBI Rest API ( I could be wrong)
Thanks,
Gio
hi Gio_Senatore thank you for the clarity and yip the API way may be the easiest, you could use python as well to perform the uploads for you (i will try it some time). i am womdering seeing the queries are being paramaterised, why a 100 dashboards, will row level security and roles not do it for you, sorry for all the questions. let me know if a pythn script isomething we should be looking into as well.