The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
I'm facing automated refresh errors in a report I have. The error message is:
All my data come from SQL.
Can you help, please?
Is the dataset refreshed before but failed currently? If all dataset settings and gateway are fine, this should be the know issue listed in Support page:
Best Regards,Qiuyun Yu
Recently I had the same isuue. The problem was in my column with date type, but in query editor it was shown as string type. For PB Desktop it was fine, but for Service it was impossible to recognize the type of column. When I`ve fixed it, my dataset was refreshed.
I found the reason of error only when I left this one table with date in my test report, so the real error was shown in service instead of "WABI-EAST-blablabla error". So you can try deleting tables one by one and publish it, then try refresh dataset and you will find the reason.
Hello @v-qiuyu-msft and @Elizaveta,
thank you for your insights. In the meanwhile, this was resolved because it was due to the error @v-qiuyu-msft refered.
Hope this will not happen in the near future 🙂
Thank you again.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.