Forum Discussion
Dataflows - refresh gives error about AzureStorage.BlobContents matches no exports
- 7 years ago
I have the same problem, i am trying to pull a table from my onpremise server to a dataflow , i can save it but when i try to refresh i get this error
Error: The import AzureStorage.BlobContents matches no exports. Did you miss a module reference? R
i know my data getaway works as i have several dataset already pulling this table from the same db server.
any idea
******* Update 15-11-2018 ************
I think, i found my problem and its working now.
i want to provide my environment and case so people can check if they have the same scenario.
1) i have enterprise data gateway installed and working for my power bi tenant, no problem here
2) i normally use a service account (Window Account) as credential to access my on Premise Data Sources
now, that service account does not have office 365 setup and power bi access, i use my personal account to create data source in the gateway but i use that service account to access my databases.
when i created the dataflow, it seems the gateway find the data source already created in my gateway but also use the credential infomation so i dont pass new credential.
i dont know how the internals of this process work but i guess the daflow use somehow those credential to do something and it fail,( i dont think the error i am getting , describe well the problem),
WorkAround, i have another data gateway and that one dont have the data source created so the dataflow process ask me for credential , when i use my personal credential that have oficce365 and power bi access correctly, it work without problem
hope this can help somebody else
Hi bdunzweiler ,
A bit late, however I can confirm rmillan 's solution.
It seems that when you setup the dataflow using the cached credentials from the Data Gateway (i.e. you let the dataflow use the credentials stored by the data gateway), you receive the error "Error: The import AzureStorage.BlobContents matches no exports. Did you miss a module reference?".
To fix this, you have to NOT use the data gateway as an option, and instead pass credentials manually. This enabled me to successfully refresh the dataflow and connect to it using Power BI Desktop. During the data load into PBI Desktop it referenced connecting to blob storage, so it appears there is some ancillary work happening in the background when the Dataflow is stored.
Regards,
Sean