Forum Discussion

Keerthika's avatar
Keerthika
Helper I
7 years ago
Solved

Configuring Data Gateway error

Hi, I used direct query to get dataset from SQL data source. I created reports in Power Bi Desktop. I published my reports to power bi service. I have installed data gateway and configured SQL data ...
Need Help
Show and Tell
Tips and Tricks
  • Keerthika's avatar
    Keerthika
    7 years ago

    Hi,

    Thanks all for your help. I sorted out the issue. The problem was that sql server has two instances in the same name. I created a new instance and configured gateway using that new instance.

    Thanks.

v-diye-msft's avatar
v-diye-msft
Community Support
7 years ago

Hi Keerthika ,

 

Please make sure you have the permission to use the gateway:

And the connection is successful when test: (Note that authentication is same as the one you filled in desktop)

Keerthika's avatar
Keerthika
Helper I
7 years ago

Hi v-diye-msft ,

I have checked all my connections.

I cannot find what the issue is.

  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    7 years ago

    Hi Keerthika ,

     

    1. Please make sure the report wasn't implemented RLS before.

     

    2. Please make sure the database you connected under the gateway is defenitely the one you used in desktop (If there another database in the same server, it can be connected as well), nor you change the date source name.