Schedule Refresh

[Sowmiya]

Hi Community,
My datasource is from Azure SQL Database. On configuring Schedule Refresh, i am getting error as "error occured when processing the data in the dataset". But My Power Bi Desktop (.pbix) file is refreshed manually, Data is getting refreshed without any error. Guide me in solving this error.

Thanks in advance,
Sowmiya

[v-yulgu-msft]

Hi @Sowmiya,

Did you combine any other data source with Azure SQL Database in the dataset?

Please refer to this blog to see if the troubleshooting tips helpful to your scenario.

Best regards,

Yuliana Gu

[Sowmiya]

Hi @v-yulgu-msft

No I didn't combine any other datasource, I just use only datas from Azure Database.

Thanks In Advance,

Sowmiya

[v-yulgu-msft]

Hi @Sowmiya,

Please open the report in Desktop, locate to Query Editor, and check if there existing any error when you apply any transformation to table "Entry_Date".

Regards,

Yuliana Gu