Forum Discussion
Datasource setting issue- suggestion
Hi All,
I used an Azure SQL Server connection with DirectQuery mode to create a report. After publishing the report in Power BI Service, I entered the data source credentials in the settings, and I received a popup message saying that the data source credentials were updated successfully. However, after a few hours, if I try to open the report again, I encounter the below issue. I enter the data source credentials again to make it work, but the problem reoccurs after a few hours.
Is there any way to update or view the username and password in the data source credential settings. Could you please provide some solution to fix this issue.
Thanks in advance.
Hi Anonymous ,
According to the description of the error message, it is possible that the user does not have the necessary permissions to perform a SELECT operation on the specified object.
You need to check if the data source corresponding to your report is given the right permissions? Or the user who is getting the data does not have proper permissions to read the data on the table.
You can refer to the following LINK:
Lakehouse sharing and permission management - Microsoft Fabric | Microsoft Learn
Share your warehouse and manage permissions - Microsoft Fabric | Microsoft LearnThis is the related document, you can view this content:
Could not load the data for this visual - Microsoft Fabric Community
Solved: SELECT Permission denied error from Power BI Desk... - Microsoft Fabric Community
Solved: Error: The SELECT permission was denied on the obj... - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
According to the description of the error message, it is possible that the user does not have the necessary permissions to perform a SELECT operation on the specified object.
You need to check if the data source corresponding to your report is given the right permissions? Or the user who is getting the data does not have proper permissions to read the data on the table.
You can refer to the following LINK:
Lakehouse sharing and permission management - Microsoft Fabric | Microsoft Learn
Share your warehouse and manage permissions - Microsoft Fabric | Microsoft LearnThis is the related document, you can view this content:
Could not load the data for this visual - Microsoft Fabric Community
Solved: SELECT Permission denied error from Power BI Desk... - Microsoft Fabric Community
Solved: Error: The SELECT permission was denied on the obj... - Microsoft Fabric Community
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.