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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Keerthika
Helper I
Helper I

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 source credentials. The connection was successful. But I couldnt view my report showing the following error,error1.PNG

I have checked all my credentials which are correct upto my knowledge. Is there any way to solve this? Any solution on this would be really helpful.

Thanks.

1 ACCEPTED SOLUTION
Keerthika
Helper I
Helper I

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.

View solution in original post

5 REPLIES 5
Keerthika
Helper I
Helper I

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
Community Support
Community Support

Hi @Keerthika ,

 

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

0010.PNG

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

009.PNG

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Hi @v-diye-msft ,

I have checked all my connections.

gateway.PNG

gateway1.PNG

I cannot find what the issue is.

Anonymous
Not applicable

Hi @Keerthika ,

a step that people sometimes miss is the user mapping explained well by GiaC:
https://www.youtube.com/watch?v=eATPS-c7YRU

Hope this helps,
Mark

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.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.