Forum Discussion
Dataflows - refresh gives error about AzureStorage.BlobContents matches no exports
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,
Can you please explain more about this?
How to Get Your Question Answered Quickly
Do you mean configure power bi on premise gateway on azure side to handle data dataflow? If this is a case, I'd like to suggest you post this to azure forum to get better support.
You can also take a look at following documents which told about how to configure on premise gateway and export blob dataflow.
Connect to data sources on premises from Azure Logic Apps with on-premises data gateway
Use the Azure Import/Export service to export data from Azure Blob storage
If you mean azure streaming analytics job, you can take a look at following link:
Quickstart: Create a Stream Analytics job by using the Azure portal
If you mean CDS for Analytics dataflow, maybe you can refer to following link: (current it seems not support azure export job as datasource)
Add data to an entity in Common Data Service for Apps by using Power Query
BTW, if your requirement is related to CDS-A, you can post this to powerapp forum for further support.
Regards,
Xiaoxin Sheng
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