Forum Discussion
ODBC integration doesn't run script
I'm trying to use a SQL script through an ODBC connection to include tables in power bi.
When I select just 1 table, the script runs normally, but when I use the joins functions and click "ok", nothing happens.
It seems that power bi keeps processing the script and in the end nothing happens.
i've tried to select each tables and it works normally.
Hi 19Murilo77 ,
1. Try running your SQL query directly in your database management system (DBMS). This can help you determine if the issue is with the query itself or with Power BI.
2. Check the ODBC Driver. If you are using the 32-bit version of the ODBC driver, try the 64-bit version of the driver, you can also try updating the driver to the latest version.
3. Similarly, you can try updating Power BI Desktop to the latest version. Sometimes, updating the software can resolve issues with certain features.
Download Power BI Desktop from Official Microsoft Download CenterBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
1 Reply
Hi 19Murilo77 ,
1. Try running your SQL query directly in your database management system (DBMS). This can help you determine if the issue is with the query itself or with Power BI.
2. Check the ODBC Driver. If you are using the 32-bit version of the ODBC driver, try the 64-bit version of the driver, you can also try updating the driver to the latest version.
3. Similarly, you can try updating Power BI Desktop to the latest version. Sometimes, updating the software can resolve issues with certain features.
Download Power BI Desktop from Official Microsoft Download CenterBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group