Forum Discussion
Unable to have Scheduale refresh
Our organization is having some issues with our dataset not refreshing. We get the following message:
xxx has failed to refresh.
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
<ccon>DataSource.Error: <ccon>Microsoft SQL</ccon>: <ccon>"User does not have permission on table incident. Line:317, Position:10" RequestId: TDS;e9f194a2-a354-45e9-afa6-bbb94c69e71f;10 Time: 2023-09-05T08:32:02.5471599Z</ccon>. DataSourceKind = <ccon>CommonDataService</ccon>. DataSourcePath = <ccon>econa.crm4.dynamics.com</ccon>. Message = <ccon>"User does not have permission on table incident. Line:317, Position:10" RequestId: TDS;e9f194a2-a354-45e9-afa6-bbb94c69e71f;10 Time: 2023-09-05T08:32:02.5471599Z</ccon>. ErrorCode = <ccon>-2146232060</ccon>. Number = <ccon>40000</ccon>. Class = <ccon>16</ccon>. </ccon>. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: incident.
How do we fix this issue?
(Please explain in a way someone who isnt proficcient in Power BI yet would understand)
1 Reply
This is a permissions error on the source system. The credentials you have used in the data source settings do not have permission to query the incident table. You need to contact the owner of the system you are sourcing the data from to get the permissions fixed or use different credentials to access the data.
