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
I know that I am very late to the party here, but I am having the same issue. The solution noted that I had to not use the data gateway as an option and pass credentials manually. I am not sure how to do this.
In reading the responses (Anonymous , rmillan ) it seems that the issue is the same for me: I have one set of credentials (Windows/Office) that I use to access the Gateway/PowerBI/SharePoint and another to access the database.
Does anyone have any updates on this? It is pretty frustrating. I can see the data in the dataflow when I create it and add the entity, but it fails on refresh. I am not sure if it makes a difference or not, but I created a blank query and am using a native database query to get the data.