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?
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
@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.
I'm having this problem too.
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.
@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.
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.