Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
hello,
i'm trying to connect my odbc datasource through on-premises gateway but it's not working.
i have one on-premises gateway and two diffrent data source like MySql and ODBC.
MySql is local DB in my system and for ODBC, i have created one system DSN.
Both are connect completely in PBI desktop but in PBI service only MySql data source is working completely, ODBC shows error as below screenshot,
Here i attach another screenshot in which i created two data sources in my on-premises gateway, both are successfully connected.
Please help me for solve this error.
Thanks in advance.
I would advise you to check the advanced editor on your desktop file and verify the connection is the same as you are plugging into the gateway. We have one data set that, if I am not careful, the desktop software lists slightly different. I have to manually change the pathway before publish for my gateway to access the data.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.