Forum Discussion

Sowmiya's avatar
Sowmiya
Helper III
7 years ago

Schedule Refresh

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

 

 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

3 Replies

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    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's avatar
      Sowmiya
      Helper III
      7 years ago

      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's avatar
        v-yulgu-msft
        Microsoft Employee
        7 years ago

        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