Forum Discussion
Refresh error on my dataset
Hi, Anonymous
If you are using the data source of the R script/Python, then you can only use a personal gateway to refresh.
Reference: Use R in Power Query Editor - Power BI | Microsoft Docs
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
hi Anonymous ! the R script is referring to a data file that is on sharepoint (an excel file). It is just a simple table with two columns : i'm trying to add the columns together in a third column.
hi Anonymous - Are you the owner of the published dataset? If yes, do you see the option of "Data Source Credentials" in the dataset properties?
You can try and re-enter the credentials for both your sources using the "Edit Credentials" option here - this should setup your credentials for refresh.
If my response helped with your question please provide a 👍 and mark the post as a solution as this will help others in the community with a similar question. Thanks!
I am the owner of the published dataset but I don't have access to "Data Source Credentials" (as you can see it is grey in the picture I uploaded)