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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
bhawnaA
Frequent Visitor

Power BI Gateway Issues

HI Team ,

I am using majorly 2 Data Sources  
1. SQL server 
2. CRM (Dataverse) 
I have a on premise gatway installed for the SQL server DS which is working fine . 
But i am getting a connectivity error while connecting to CSD . 

This is a critical issue. All the help is appreciated .

bhawnaA_0-1696905372405.pngbhawnaA_1-1696905483255.png

 

 

bhawnaA_0-1696905866293.pngbhawnaA_1-1696905998542.png

 

6 REPLIES 6
lbendlin
Super User
Super User

What exactly is the issue?  You need to map your SQL server connection. Use the dropdown, then Apply.

@lbendlin 
Thanks for the reply ! but as displayed in the images the above , The issue is not the SQL . As Stated the Sql server connection works Fine . The issue is with the CDS connectivity .
When i try to add Dataverse URL by clicking on manually add to Gateway and create new connection it doesnt get attached to the Dataverse Connection

bhawnaA_0-1696989592028.png

 

Are you trying to merge these data sources in Power Query?

Yes , In some cases Yes ! @lbendlin 

Please don't.  As soon as you merge on-prem and cloud data sources in Power Query bad things will happen

 

- you need to set your gateway to allow refresh of cloud data sources

- you need to add the cloud data source to the gateway

- you can never go back from that

 

So please don't.

i am merging two tables ( both of them from datverse ) 
also i have enabled  refresh of cloud data sources

bhawnaA_0-1697061876350.png

When i manually try to add the cloud data source to gateway it gets added and appears in the connections but it doesnt get mapped as in it doesnt appear in the box or in  the drop down

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.