Automating Publishing

[Gio_Senatore]

Hello,

I am looking for a way to automate the publishing process for a dashboard from Desktop to Power BI services. I want to automate this process as I have several dashboards that are visually the same, however I filter the data using a query parameter (Which can be edited in Power BI services). Any information would be greatly appreciated. 

Thanks,

Gio

[Gio_Senatore]

Hello,

Thanks, I would really appreciate it.

[rubinboer]

hi there, best is to publish the page to the service when you have completed the report. The refresh only update the data (semantic model), powershell has been well documented as shared already to upload multiple files, i will create a python script to do the same and share it here in a day or two. 

[VijayP]

@Gio_Senatore  Try this 

https://github.com/Microsoft/Reporting-Services/tree/master/APISamples/powershell

[VijayP]

@Gio_Senatore  There is one option to publish reports ( it is not dashboard) to service is you can select and  upload the pbix file from workspace directly! but again here it is one by one! but no need to open pbix.

You can use Rest API using C# , let me see if I could give one..

[Gio_Senatore]

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

[rubinboer]

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.

[VijayP]

@Gio_Senatore 

Data Gateway is a must for autopublishing ( aka Scheduled Refresh) for  your problem statement!

[rubinboer]

hi @Gio_Senatore 

Does the scheduled refresh in the service (gateway setup i assumed) not meet your requirement? If your requirement is more complex than provided by the service and gateway can you please share a bit more on that.

[Gio_Senatore]

Hello,

Will a scheduled refresh update the report itself, so If I added additional pages would they be added or does the refresh only update data?

Is there any option to automate publishing using python? 

Thanks,

Gio