Forum Discussion

ahmadov_10's avatar
ahmadov_10
Icon for Helper II rankHelper II
3 years ago

Refresh fails first attempt (reason : data format) and success second attempt

Hello Experts, I'm working on a Power BI report that takes a MySQL database as its source and I'm updating the data via the gateway. I'm facing a recurring problem that I can't find a clear explana...
Need Help
rubayatyasmin's avatar
rubayatyasmin
Icon for Community Champion rankCommunity Champion
3 years ago

ahmadov_10 

 

interesting that the first attempt fails and the second succeeds. Are there any processes that might be conflicting with the first refresh attempt? Maybe another process is locking a table or altering data at that time.

 

Also, is it possible that your MySQL DB updates/writes data at 9 UTC? Probably that is causing the issue. Try changing the schedule refresh time. See if that works. 

 

Also, from this doc, 

  • Gateway process may have restarted when the dataset refresh was in progress.

 

https://community.fabric.microsoft.com/t5/Service/Gateway-Mashup-Data-Access-Error/m-p/1386953

 

https://community.fabric.microsoft.com/t5/Desktop/Power-BI-dataset-refresh-issue/td-p/2677275

 

Did I help? If yes, hit 👍 and accept this answer as solution. 

  • ahmadov_10's avatar
    ahmadov_10
    Icon for Helper II rankHelper II
    3 years ago

    Hello , the problem i can't confirm if the team worked in the database source (my SQL) is updating database at 9h00 but if find a temporary solution : 

    1st schedule at 9h00 : fails 

    2nd schedule at 9h30 : success with any problems

    so logical , it cannot be a problem of confilcts but it seems at some readed data at the first time not well interpered (compiled in the format , for this reason the error message : Input string was not in a correct format) and after it works : the unique explanation that i find .

     

    Kind Regards