Automating publishing to Powerbi and Moving PBIX File

[MarkPHarris1]

Hi There,

To give a bit of background we currently use sharepoint document libraries to act as version control for our PBIX files. After uploading to here we then open and publish the report to the powerbi service. To be honest I often forget to do the first part of this, what I wanted to ask is is there a way of automating these two steps into one script? My first thought is using powershell and the rest api to publish(and replace a existing report more often then not) then move the file to a sharepoint location. Has anyone had any experience of doing this?

Also out of interest as a Power BI developer is it worth learning powershell if I'm not a admin or work in IT creating workspaces etc?

Thanks for your help,

Mark 

[lbendlin · Accepted solution]

You may want to consider the checkout/checkin feature of Sharepoint and leave your PBIX file there all the time (rather than re-uploading).

And yes, learning Powershell is definitely a good idea, even if only for local automation.  Also look at the Power BI API documentation.