cancel
Showing results for 
Search instead for 
Did you mean: 

Using Blank Query when creating Dataflow gives error

When making a new Dataflow, using the blank query option with a custom connector I continously get the following error:

 

"We encountered an error during evaluation. Details: Something went wrong while retrieving details for the on-premises data gateway. Please try again later."

 

Yet there is no issue with the Gateway/custom connector as publishing reports from Power BI Desktop to Power BI Online works fine. How can we get this to work?

Status: New
Comments
Moderator

Hi @xhenipash

 

Currently, the dataflow doesn't support all of data sources. Which data sources do you want to connector. Please check if the data source is supported for dataflow based on this document: https://docs.microsoft.com/en-us/power-bi/service-dataflows-data-sources

 

 

Best Regards,
Qiuyun Yu

Visitor

@v-qiuyu-msft  Hi, thanks for the response. I am using the blank query with a custom connector that is based on ODBC, I also tried it with ODBC and I run into the same issue. And as far as I can see from the provided link "connectors you can currently use by copying and pasting the M query into a blank query:" ODBC is in that list.

 

 

New Member

I'm having this problem too.

Moderator

Hi all,

 

Please ensure the same ODBC data source already created in Manage Gateways section. Then please create a dataflow with Blank Query, select the specific gateway which has ODBC data sources created. If the same issue occurs, I would suggest you create a support ticket to get help. 

 

Support Ticket.gif

 

Best Regards,
Qiuyun Yu

Visitor

@v-qiuyu-msft I have done what you mentioned. Unfortunately, I do not currently have a Power BI Pro account as I am testing utility and so I cannot open a support ticket.

Frequent Visitor

For us, a user can create a BW dataflow if they are set as an admin on the gateway, but they get this error if they are just a user of the BW datasource in the gateway.