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
Hi All,
scheduled refresh is failed for onprimises Sqkserver datasource with the following error message
I have configured gateway and added the datasource successfully to the gateway but still it is failing
Kindly Help:
Solved! Go to Solution.
Hi @pbapuji ,
Please clear the global permission, re-connect to the data source and try to refresh manually in Desktop. Then republish the report to service and check if it works fine when you set schedule refresh.
Moreover, make sure that you install the latest version (3000.10.232) of gateway and the latest version (2.74.5619.621) of Power BI Desktop. And please check if your dataset matched the gateway.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
Hi @pbapuji ,
Do the data source schedule refresh successfully? If yes, please mark helpful or prefer replies as answers. So that we are able to close the thread. More people will benefit from here. If no, do you try the way that I suggested? Is there any error message?
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @pbapuji ,
Do the data source schedule refresh successfully? If yes, please mark helpful or prefer replies as answers. So that we are able to close the thread. More people will benefit from here. If no, do you try the way that I suggested? Is there any error message?
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
My deepest apologies, I was in sick leave, sorry for the delay.
I am checking now , will provide you the update ASAP.
Thanks,
Bapuji.
Hi @pbapuji ,
Please clear the global permission, re-connect to the data source and try to refresh manually in Desktop. Then republish the report to service and check if it works fine when you set schedule refresh.
Moreover, make sure that you install the latest version (3000.10.232) of gateway and the latest version (2.74.5619.621) of Power BI Desktop. And please check if your dataset matched the gateway.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Kudos are nice too.
Hi All,
I have tried with latest version of the gateway, now it's successful.
Thank you so much for your help.
Bapuji.
Try to reset the gateway,
I solved some problems with auto refresh last week
Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.