Forum Discussion
Scheduled Refresh Disabled and Data Source Settings Unavailable in Power BI Report
Hi rajendraongole1 thanks for ur respond so basically when i publish the report i didnt get any warning or error everything is okay and now my data source is grey out i also can click on it. A u can see on my attached image its grey out.. if i dont have any access or gateway problem for sure i cant access to the data right? i really need ur insight on this error .
Super UserHi Anonymous - might be it looks like there could still be permission issues causing the credentials to be inaccessible. Ensure that your account has the necessary permissions for both the Power BI workspace and the SQL Server database.
Since your connection to the SQL Server is via Personal Access Token (PAT), the token may have expired or been revoked on the SQL Server side. If this happens, Power BI will still show the dataset but won’t allow refreshes.
Try generating a new token and updating the credentials in Power BI Service by navigating to Settings > Datasets > Data source credentials and inputting the new token.
Reference link:
Data source credentials and scheduled refresh grey... - Microsoft Fabric Community