topic Re: How to Publish multiple reports to Power BI instance in Developer

How to Publish multiple reports to Power BI instance

nagesh4641 — Mon, 13 Mar 2017 20:56:37 GMT

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

Re: How to Publish multiple reports to Power BI instance

Reid_Havens — Mon, 13 Mar 2017 20:58:56 GMT

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?

Re: How to Publish multiple reports to Power BI instance

nagesh4641 — Mon, 13 Mar 2017 21:00:18 GMT

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

Re: How to Publish multiple reports to Power BI instance

Reid_Havens — Mon, 13 Mar 2017 21:01:38 GMT

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?

Re: How to Publish multiple reports to Power BI instance

nagesh4641 — Mon, 13 Mar 2017 21:02:50 GMT

that's correct ,

Re: How to Publish multiple reports to Power BI instance

Reid_Havens — Mon, 13 Mar 2017 21:05:31 GMT

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.

Re: How to Publish multiple reports to Power BI instance

nagesh4641 — Mon, 13 Mar 2017 21:10:03 GMT

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

Re: How to Publish multiple reports to Power BI instance

Reid_Havens — Mon, 13 Mar 2017 21:24:34 GMT

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).

Re: How to Publish multiple reports to Power BI instance

nagesh4641 — Mon, 13 Mar 2017 21:27:12 GMT

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

Re: How to Publish multiple reports to Power BI instance

TedPattison — Tue, 14 Mar 2017 01:53:35 GMT

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.

Re: How to Publish multiple reports to Power BI instance

Eric_Zhang — Wed, 15 Mar 2017 06:58:19 GMT

@nagesh4641

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