Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
--> 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.
Does anyone know a solution for this?
Thanks
Solved! Go to Solution.
Solved.
The pbix file had two data sources ODBC and a web source, removing the web source from the file resolved this issue.
Solved.
The pbix file had two data sources ODBC and a web source, removing the web source from the file resolved this issue.