Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Data Gateway error

Hi   My client has moved their SQL-server to a new IP-address. After this I can not get the data gateway to work. It works in the desktop and after publishing I want to configure the datagateway wi...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Found the error. It turns out that when providing a Port-no it has to be preceeded with a "," and not a ":" as in the desktop (and elsewhere).

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Found the error. It turns out that when providing a Port-no it has to be preceeded with a "," and not a ":" as in the desktop (and elsewhere).

SidraM's avatar
SidraM
New Member
6 years ago

Anonymous How did you change ":" to ","? The option is greyed out for me when I open my dataset on Power BI service. Thank you!

 

UPDATE: I was able to change it in Power BI desktop and publish the dataset again. Thank you so much for sharing your solution! I spent DAAAAYS trying to figure out why I wasn't able to connect.

  • bo_afk's avatar
    bo_afk
    Post Patron
    5 years ago

    Hi Anonymous  SidraM, I'm also getting the same issue, where can I find the option to change the Port-no?

    • SidraM's avatar
      SidraM
      New Member
      5 years ago

      Go to File > Options and settings > Data source settings

       

      From there you should be able to update port# using Change Source option.

      • bo_afk's avatar
        bo_afk
        Post Patron
        4 years ago

        I'm trying to set up a gateway within PowerBI service within one of my Gateway clusters but I don't seem to be able to see this option in there?