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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
PPK
Frequent Visitor

Not able to select ODBC on-premises gateway connection

Hello,

 

I am having trouble using the on-prem gateway with ODBC:

 

1. I created a system dsn that points to the data i want to use, at first i had an error 5033 which said that no connected server was found for the given drive letter. I managed to resolve this by using the full UNC path.

 

2. I linked this ODBC to my dataset and published it to Power BI Service

 

3. I added the data source in Power BI Service, which seems to connect succesfully 

 

PowerBI1.png

 

--> What are the credentials to be used here? Credentials that were used to setup the gateway / credentials that were used when the odbc source was imported in power BI / .. ? 

 

4. On the dataset - settings tab I am unable to select the gateway, as it does not show up.

PowerBI2.png

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Does anyone know a solution for this?

Thanks

1 ACCEPTED SOLUTION
PPK
Frequent Visitor

Solved.

 

The pbix file had two data sources ODBC and a web source, removing the web source from the file resolved this issue.

View solution in original post

1 REPLY 1
PPK
Frequent Visitor

Solved.

 

The pbix file had two data sources ODBC and a web source, removing the web source from the file resolved this issue.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

Top Solution Authors