Forum Discussion

jeremyt's avatar
jeremyt
Frequent Visitor
10 months ago
Solved

IP Address for Power BI Data Flow Not Working

I have a mysql database I need to read in using a Dataflow Gen1 on my Power BI service. We are US based organization (WA state if that matters).   I've seen a few different questions point to this ...
Dataflow
Need Help
  • tayloramy's avatar
    tayloramy
    10 months ago

    Hi jeremyt, 

    I had assumed that. I knew that there were some endpoints other than powerbi.com ones that were required for dataflows, and the easiest place to find them was the gateway documentation. 

     

    I think if you allow the gateway ports on your EC2 server, it should allow everything for full communication. 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

     

jeremyt's avatar
jeremyt
Frequent Visitor
10 months ago

Thanks tayloramy  for the pointers. One thing I should have mentioned in my question (and I'll add it now) is that I don't have an on prem data gateway, and am hopoing to have my dataflow to talk to my MySQL database on an EC2 server directly.

tayloramy's avatar
tayloramy
Super User
10 months ago

Hi jeremyt, 

I had assumed that. I knew that there were some endpoints other than powerbi.com ones that were required for dataflows, and the easiest place to find them was the gateway documentation. 

 

I think if you allow the gateway ports on your EC2 server, it should allow everything for full communication. 

 

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

 

  • jeremyt's avatar
    jeremyt
    Frequent Visitor
    10 months ago

    WINNER WINNER CHICKEN DINNER!

     

    That worked perfectly! I added the IP Addresses for all the GatewayManager.*US objects and things worked perfectly.

     

    THank you for all your help!