Forum Discussion

alanc's avatar
alanc
Frequent Visitor
2 years ago
Solved

Unable to create Data Source Connection (no values in Gateway Cluster dropdown?)

I'm trying to create an On-Prem connection for Power BI and it doesn't show any values in the dropdown, I had a previous connection (Personal mode) and I couldn't update it as the connection name was...
Need Help
  • alanc's avatar
    alanc
    2 years ago

    It seems the crux of my problem was the connection string, when using Import mode and specifying the SQL port my string was this... myserver\mysqlinstance:50560;myDB and it worked fine for many months. However when changing to using DirectQuery it wanted the string to be myserver\mysqlinstance,50560.  That is a comma instead of full-colon. So now I can access my local datasource using DQ (desktop) without a gateway, no issue, and also now understand when and how the gateway needs to be setup.

     

Greg_Deckler's avatar
Greg_Deckler
Community Champion
2 years ago

alanc I guess the first question is do you have a gateway installed and signed-in to the Service?

alanc's avatar
alanc
Frequent Visitor
2 years ago

I do not have a gateway installed, my understanding was a gateway is not required when accessing a local DB instance, the problem was I blew away the existing default and now I can't recreate it.