Forum Discussion
Helper IDataset refresh failure in Power BI service
Hello All,
I have one PBI report that keeps failing to refresh. I have several other reports that refresh properly, so I can't figure out the issue. Attached are the failure details.
Thanks in advance
Hi Anonymous,
Thanks for replying the actual issue here is the account used for creating gateway connection does not have previlages to execute select permission. After providing permission, dataset refreshed successfully.
3 Replies
Hi Ynr0225 ,
Ensure that the credentials used to access the data source are correct and have the required permissions. The error message mentions that the user does not have the required login rights to the database.
You can try deleting the dataset from the Power BI service and then republishing it from Power BI Desktop
Below is the link will help you:
Solved: Refresh Failed - Internal Service Error - Microsoft Fabric Community
Solved: Dataset refresh fails due to internal server error... - Microsoft Fabric Community
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Ynr0225Hi Anonymous,
Thanks for replying the actual issue here is the account used for creating gateway connection does not have previlages to execute select permission. After providing permission, dataset refreshed successfully.
