Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gmurdoch_85
Frequent Visitor

Using a DNS address to connect to a MYSQL database

Hello,

 

I currently connect to a MQSQL database through power query using the syntax IP:Port , I've just found out that the IP address is actually dynamic and changes without warning every now and then. Is there a way that I can connect to PBI using the DNS address? Everytime I've tried this it won't work and I can only connect using the IP.  Has anyone run into this problem before?

 

Baicaslly I'm looking for a way to connect to a dynamic IP address or a DNS address within Power BI. 

 

Cheers!

1 REPLY 1
lbendlin
Super User
Super User

Yes, you can use the FQDN of the load balancer.  What error message do you get and does your load balancer owner have an opinion on that?  (Asking because I know that we had a lot of issues with ODBC connections to load balancers and had to work with Microsoft and the data system owner to fix that connector).

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors