Forum Discussion
Scheduled refresh not working properly
Hi,
We have a report where scheduled report does not work properly, sometimes it goes through and the next time it disabled the scheduled refresh, with the following message:
-Report is on premium capacity workspace (trial version) and is embedded (needs embedded capacity). ---> manuell refresh of the report in the service works most of the time.
-Moving report to pro workspace, scheduled refresh works fine.
What might be the cause of the failure of the scheduled refresh????
2 Replies
arichard19Resolver I
If you have heterogenous data sources/database (more than one different source of data - non-homogenous) which are being appended or merged within Power Query, Schedule Refresh outside of a premium capacity will often break.
You can solve this problem by first creating Data Flows or event a Data Mart which will make the non-homogenous sources, homogenous
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service
https://docs.microsoft.com/en-us/power-bi/transform-model/datamarts/datamarts-overviewarichard19 tnx for your reply/suggestions.
Report scheduled refresh is inside of a premium capacity btw, and there it often breaks.
Have tested scheduled refresh of the report in a pro (outside of premium) workspace and scheduled refresh works fine.