Forum Discussion
Issues with Scheduled Refresh on Power BI Service Using Dataflow Source
1. The data was moved from the database to a Power BI dataflow.
2. The Power BI PBIX file is connected to the Power BI dataflow as the data source.
3. When refreshing the Power BI PBIX file from the desktop, the data refreshes successfully.
4. However, the scheduled refresh on the Power BI service is failing, despite using the same dataflow source.
Please Advise on How to Resolve
5 Replies
Hi bientution
If Power BI scheduled refresh is failing in the service while the desktop refresh with the dataflow works,
I think reason is an issue with the on-premises data gateway configuration or permissions on the Power BI service side, like incorrect credentials, gateway not running. Pls check this before scheduling refresh.
Pls check with this urls
https://community.fabric.microsoft.com/t5/Service/Scheduled-Refresh-not-updating-with-latest-data-despite-refresh/m-p/3025232#M185624Sorry, I have edited the post and included the correct issue
Hello bientution ,
if it's related to this error
The OData connector failed with the following error: We cannot convert the value null to type Record
then you need to change something in Power query => advanced editorave you tried the fix on the below link?
https://www.reddit.com/r/PowerBI/comments/1f7yadg/data_conversion_error_on_refresh/
We encountered the same error and by adjusting the 4th parameter on the API call, the problem went awayBefore:
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null)After:
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = null])Sorry, I have edited the post and included the correct issue
yes, bientution
if the error is like this one The OData connector failed with the following error: We cannot convert the value null to type Record
then you need to check the advanced editor of each table in your data flow and if it's reading from an api then you should adjust it as the followingefore:
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null)After:
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = null])
you need to add in the last parameter instead of null to [UseReadOnlyReplica = null]
