Forum Discussion
Excel data refresh error
Hi siddhant-croma ,
To that option is greyed out. You have to expand the Gateway connection which will then enabled the data source credentials.
And then from the error you should be able to update your credentials for your data source.
Once you've added these data sources to the gateway, you can set up the data source credentials and it should refresh!
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.
Hi siddhant-croma ,
Welcome to PowerBI buddy.
It seems that powerbi isnt able to access your data connection to the excel.
When you connected your powerbi to excel was it from your local file or the onedrive file ?
You may want to go with the one drive file.
Also note that the email id you are using for one drive is the same id should be using in data source credentials or atleast have an access to the one drive.
Let me know if this helps.
Hi Gayatri,
Thanks for the reply.
But the problem is not the one which you've described.
I have created the report on Onedrive excel file.
I have logged in through same email ID. But the semantic model doesnt refresh itself. Neither does it allow me to refresh manually as scheduled refresh is aparently disabled.
Error text: "Data source errorScheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh."
As per the instructions given, I tried opening Semantic data settings and looked for "Data sourse credentials". But that option is greyed out (unavailable to select).
Please refer screenshots to understand better-
Semantic model setting: Credentials are disabledMy workspace: Semantic model doesnt allow refresh