Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

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

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-ta...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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's avatar
ibarrau
Super User
3 years ago

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,