Forum Discussion

wrwillits's avatar
wrwillits
Helper III
5 years ago
Solved

Missing Connectors for Dataflows

I am trying to use Dataflows to connect to my data but a number of the connectors that are available in PowerBI are not available in Dataflows. Why is that seeing that Dataflows are basically a cloud...
  • v-jingzhang's avatar
    5 years ago

    Hi wrwillits 

     

    Although we may think of Dataflow as Power Query online version to understand it more easily, it is not the completely same tool as Power Query Editor. As it is in the service, the logic to design and develop a connector will not be a simple copy of the on-premises version.

     

    You can find out all currently supported connectors from below links. They also indicate which ones are currently supported in Power BI Dataflow. 

    List of all Power Query connectors | Microsoft Docs

    Power BI data sources - Power BI | Microsoft Docs

     

    There are additional data connectors that aren't shown in the Power BI dataflows user interface, but are supported with a few additional steps. You can first connet to them in Power BI Desktop. Then copy the M codes from Advanced Editor and paste it into a blank query in a dataflow. Please refer to Connecting to additional data sources

     

    For other unsupported connectors, we may see them become available in the future. You can get the latest news about new features from Power BI Blog

     

    Hope this helps.

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as the solution to help other members find it.