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...
Need Help
Tutorial Requests
  • 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)

lbendlin's avatar
lbendlin
Super User
3 years ago

 

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
3 years ago

Can you please specify the steps that I have to follow

 

  • lbendlin's avatar
    lbendlin
    Super User
    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)