Issues with Scheduled Refresh on Power BI Service Using Dataflow Source

[bientution]

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

[Idrissshatila]

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 editor

ave 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 away

Before:
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null)

After:
Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = null])

[bientution]

Sorry, I have edited the post and included the correct issue

[Idrissshatila]

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 following 

efore:
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]

[suparnababu8]

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-de...

https://community.fabric.microsoft.com/t5/Service/Manual-refresh-works-but-Scheduled-refresh-does-no...

[bientution]

Sorry, I have edited the post and included the correct issue