Forum Discussion

Anandhu12's avatar
Anandhu12
Frequent Visitor
3 years ago
Solved

Creating Dataflow from data loaded using OData connection

Is it possible to load data to create a dataflow using OData connection in Power BI service? 

What are the steps to follow inorder to establish the connection?

If there is a Gateway installed how I can connect Odata using Gateway?

 

I have a custom OData connector added in the Power BI Desktop.

  • lbendlin's avatar
    lbendlin
    3 years ago

    1. Identify the service account that the gateway is running under

    2. Identify the Documents folder location for that account based on the Windows version.  For example for Windows Server 2019 images the folder is at

     

    C:\Windows\ServiceProfiles\PBIEgwService\Documents\Power BI Desktop\Custom Connectors

     

    3. Put the .mez in that folder

    4. In the gateway management interface make sure the connector is listed under custom connectors.

     

     

    (note that screenshot is from a Windows Server 2012R2 image)

3 Replies

  •  

    I have a custom OData connector added in the Power BI Desktop.

     

    you need to add the .mez file to the gateway cluster members as well.

    • Anandhu12's avatar
      Anandhu12
      Frequent Visitor

      Can you please specify the steps that I have to follow

       

      • lbendlin's avatar
        lbendlin
        Super User

        1. Identify the service account that the gateway is running under

        2. Identify the Documents folder location for that account based on the Windows version.  For example for Windows Server 2019 images the folder is at

         

        C:\Windows\ServiceProfiles\PBIEgwService\Documents\Power BI Desktop\Custom Connectors

         

        3. Put the .mez in that folder

        4. In the gateway management interface make sure the connector is listed under custom connectors.

         

         

        (note that screenshot is from a Windows Server 2012R2 image)