Support for custom connectors in Dataflow

[derek_luo1]

Allow custom connectors developed for rest APIs/ODBC to be used the same way how they can be in PBI services. This would open much more opportunity for dataflow service to be used as a "data warehouse like" environment.

[yannick_einswei]

Please add BigQuery as online data source, with native API calls to leverage Cloud-to-Cloud transfers. Current workaround is cumbersome and inefficient as result data flows through locally: Dataflows ODBC data source -> Gateway to Simba's ODBC driver -> records from BigQuery.

[ruben]

Please add a Google BigQuery connector for Dataflows.

[dcisnerosmarin]

ODBC Connector for Dataflows

[djohnson8]

Please add support for Google BigQuery to Dataflows.

[tmckenzie3]

This really would open up the possibilities of the work that can be done in dataflows. I have a custom connector which pulls data from an API. I am wanting to stage historical data in a dataflow to set different refresh schedules against each stage, therefore I don't need to pull the lifetime data from the API, which is hitting my API call limit.

[fbcideas_migusr]

As our business analysts are becoming more adept at preparing data with Power Query "M" scripts, we are finding that collaborators want to be able to reuse the results in products besides PowerBI Desktop. It would help to have ODBC driver support to allow other analysts the ability to query the dataflow in the tool of their choice. Not all organizations have the ability to configure their own Azure Data Lake Storage or the expertise to expose the content of the Common Data Model in a business analyst friendly way. That could also help to address another idea for allowing Excel to connect to Dataflows until a native connector could be made available within the Office client.

[josh_bafford]

I agree. This would also increase adoption of PBI as people are comfortable and familiar with ODBC.

[adamlamarh]

Upvoting this. Would love to see it.

[shankar_bic]

Any ETA on this? Is it in the roadmap for Dataflow?

[JGibby]

Power BI REST API custom connector from a Dataflow makes sense

Query the data once from a dataflow, why query it again and hit the API limits?