Forum Discussion

stevemccall1's avatar
stevemccall1
Frequent Visitor
3 years ago
Solved

Connecting to a local API via data gateway

Hi,   Hope someone can help.  I've set up a local API that is accessible via a data gateway in PowerApps and want to query a dataset against this.  I can't find any documentation on how to do this ...
General Comment
  • lbendlin's avatar
    lbendlin
    3 years ago

    Well, that's not really "local".  How are you planning to do development work?  Running Power BI Desktop on a VM that is in the same subnet?

stevemccall1's avatar
stevemccall1
Frequent Visitor
3 years ago

Hi,

 

I just get this error:

 

How do I get PowerQuery to use the data dateway?  The API is only accessible via the gateway.  

 

For reference - this works fine if I go to a web API 

 


But I'm unable to use that API for my solution.

lbendlin's avatar
lbendlin
Super User
3 years ago

Sorry, I had assumed that you had already set up the gateway. It is always required for on-premise data sources.

  • stevemccall1's avatar
    stevemccall1
    Frequent Visitor
    3 years ago

    Yes - the gateway is set up and works fine when accessing via powerapps, but I don't know how to access using PowerBI.

    • lbendlin's avatar
      lbendlin
      Super User
      3 years ago

      You need to create another connection in the gateway. Power BI works different from PowerApps . You cannot share connections.

      • stevemccall1's avatar
        stevemccall1
        Frequent Visitor
        3 years ago

        Ok - that sounds reasonable - how do I do that?