I try to schedule an automatic refresh of my dataflow which is conected to a datalake Storage Gen 2. When I refresh it "on demand", it works properly but the automatic refresh fail with the following error:
"Data source credentials are missing or invalid. Please update the credentials for AzureDataLakeStorage in dataflows settings page and try again"
How the credential used for the automatic is stored ? How can we checked it's properly configured?
Each time I'm going to the parameters of the dataflow, I got this message in identification information for the datasource:
I update identification information by conecting my account but it's like if my account's parameters were not stored ...
Any idea ?
Hi @frenchphil ,
You are correct that you don't need a gateway but you will need to set the credentials in the Service in the dataset. This blog has a great example at this point "
at this link:
Thanks for the blog, it's well explained and usefull. I hadn't registered the credential at the dataset level. I thought it was my mistake ...
I tried again a scheduled refresh yesterday and it worked.
But this morning, the scheduled refresh failed again (with same error) and when I come back in the parameters of my dataflow, the credentials are not set ...
In the dataset, it's correctly registered:
Hey @frenchphil ,
If you are an admin and/or the owner of that report, when you changed the settings it should have held. I would try it again (add your credentials and refresh it) and then check again tomorrow. If it goes away again, I would contact Microsoft support because it should stay in place.
I am the owner of the dataflow and admin of my organization.
I've done it several times (see above) and it never stays in place more than one hour (approximately). For information, I use the OAuth2 authentification method.
Hey @frenchphil ,
I think you may have to open a ticket with Microsoft. Seems like some sort of cacheing maybe? But, settings (almost by definition, need to be permanent or we would all spend our whole day resetting everything 🙂 )
Sorry for that, We cannot reproduce the issue here and also not found an effective solution. We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you @collinq for your answer ...
In my case, I don't have and don't need any gateway because the Datalake is stored in Azure Cloud. It should be possible to schedule a refresh without a gateaway, no?
I have read the articles but I don't have the hand on Datalake administration .. I can make the demand if it's necessary but I don't understand why it works on demand on why it doesn't when it's scheduled ...
Hi @frenchphil ,
If you are able to run the report yourself and the gateway is not, then the issue is most likely not the userid but the ability of the user to navigate from the gateway to the data lake.
(You may also want to make sure your gateway is updated.)
Here are a couple links to help you determine the permissions:
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!
At the monthly call, connect with other leaders and find out how community makes your experience even better.
Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!