Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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 ?
Thanks
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:
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @collinq
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:
Any idea?
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.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Hi @collinq
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 🙂 )
Proud to be a Datanaut!
Private message me for consulting or training needs.
Allright, I can open a ticket. Never done it before. What is the best way to do it ?
Hi, @frenchphil
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/
Best Regards,
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:
Configuring dataflow storage to use Azure Data Lake Gen 2 - Power BI | Microsoft Docs
Solved: Re: Can't find "Power Query Online" in Azure Activ... - Microsoft Power BI Community
Proud to be a Datanaut!
Private message me for consulting or training needs.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.