Power BI - Premium per Capacity Workspace - Published Report automatic Refresh?

[Anonymous]

Hello Everyone, 

I have read through a fair few scheduled refresh problems and solutions, but I fear that they are perhaps either a step ahead of me, or just not quite the same... (totally self-taught and relatively new Power BI user here)

I have a Premium per Capacity Workspace, to which I publish reports which are built (and maintained) via my local Power BI desktop App. The purpose here is that many users across the business can thus acccess the maintained report, but not the pbix file or the detailed data model etc.

The reports that are built and maintained are fed by source data which is held in SharePoint folders. These raw data files can be updated regularly, but then what I must do is open each PBIX file and refresh and republish. 

What I would dearly love, is to understand how I could schedule the refresh of the PBIX files, including the re-publish of the reports to the Premium per Capacity workspace.

Can anyone tell me whether this is possible? If so, where do I start? 

I dont see any options to "schedule refresh" in the PBIX file

Thank you 

[Anonymous · Accepted solution]

Hi Ibarrau

Thank you for your reply

I think i may be homing in on what i wanted though

As mentioned, once the file was built from the desktop pbix, it was publised to a Premium workspace

In there, once I sorted out my credentials,  I seem to be able to schedule refresh:

So, will see if this works as intended... wish me luck! 

[ibarrau]

Hi. I don't think you can refresh pbix files like that. That's a development file so it's manual refresh. However if the schedule refresh is configured at service, it usually refreshes the report right after publish the report. That means if you just publish the file a refresh will be triggered.

If you want to make sure you can write a script and use the PowerBi Rest API. You can import (publish) pbix files and refresh datasets with it. You might be able to have a script that reads pbix from sharepoint, then imports and then refreshes.

You can read more about power bi rest api here: https://learn.microsoft.com/en-us/rest/api/power-bi/

You need to know a langauge code to write the script and you are ready to go. There are languages like powershell that will have official cmdlets to work with the api and other like Python with custom libraries from community like SimplePBI to help you dealing with API.

I hope that helps,