How to Publish multiple reports to Power BI instance

[nagesh4641]

I would like to publish around 10/ 15 reports every week -- is there a automated approach for make them published to power bi instance thru script

[TedPattison · Accepted solution]

You could write a custom application which uses the Power BI REST API to accomplish this. If writing a custom application in C# is an option for you, you can write your application code to upload PBIX files to either a personal workspace or a group worksapce in PowerBI.com. This gives you the same result as publishing a project in Power BI Desktop. If you go down this road, you must learn how to register your application with Azure AD and how to configure permissions for the Power BI REST API.

[Eric_Zhang]

@nagesh4641

An addition to @TedPattison, Check this sample getting-started-for-dotnet-import in Github.

[Reid_Havens]

Hi @nagesh4641,

Is the data kept in a cloud based or server location that you could use the "Scheduled Refresh" feature with on PowerBI.com? 

[nagesh4641]

thanks for quick reply, i have new set of 10/15 reports every week.

[Reid_Havens]

Hi @nagesh4641,

I'm not sure I fully understand. Are you saying you create 10-15 new .pbix reports each week from scratch? Compared to building a report and has data refreshed into it?

[nagesh4641]

that's correct ,

[Reid_Havens]

I'm curious about the scenario you have that requires new reports to be created as opposed to refreshing a current report each week. What is the business requirement that necessitates a new report each time? PowerBI is optimally designed to upload a report to have a report uploaded, then connect to a gateway that provides new data to that report at a scheduled refresh interval or live connection through a tabular or cube model.

[nagesh4641]

do you aware of any script to publish multiple reports  at single execution??? , rather than 1 by 1 ?

[Reid_Havens]

I think would need to download an external software macro tool to accomplish this. PBI doesn't have a feature for bulk uploads of new reports (to my knowledge).

[nagesh4641]

thanks Reid , i did enough investigation on the same, let me write a mail to Microsoft. and update the forums with microsoft response