Forum Discussion
dataset refresh failed
- Anonymous7 years ago
shuaho If M has to 'fetch' data from a source, you need to supply some form of credentials, unless you can use anomyous. Have you tried that option?
- 7 years ago
Anonymous thanks for replying. Yes, I need to set it as 'anonymous' credentials. And set a 'GET' request reachable endpoint to make the refresh job work.
Thanks !
In your Power BI Service, inside the workspace that houses this report, go into the "Settings" area and look for the Datasets section. On this list should be your dataset for the report you are having trouble with. Click on that report and look for a section on the right called "Data Source Credentials". Check that each data source as I would suspect some will have a Cross in a circle and tell you that the credentials have failed.
yes there are 3 yellow ciccles saying credential issues.
But when I try to set credentials, there are only 'anonymous, windows and basic' 3 ways
. None of them meets with our case.
I would expect the refresh job run the M script that generates the dataset, so the script will automatically get authentcated itself and fetch data.
Is it possible?
- Anonymous7 years agoNot applicable
shuaho If M has to 'fetch' data from a source, you need to supply some form of credentials, unless you can use anomyous. Have you tried that option?
- shuaho7 years agoFrequent Visitor
Anonymous thanks for replying. Yes, I need to set it as 'anonymous' credentials. And set a 'GET' request reachable endpoint to make the refresh job work.
Thanks !
- digs656 years agoNew Member
I am having similar issue, but I believe mine is because I have used an excel file as one of my queries along with querys from OData feed. Am I still able to schedule a refresh on a report that has multiple types of queries in it? Thanks.