Forum Discussion

19Murilo77's avatar
19Murilo77
Frequent Visitor
2 years ago
Solved

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", noth...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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 Center

    Best Regards,
    Gao
    Community Support Team

     

    If 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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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 Center

Best Regards,
Gao
Community Support Team

 

If 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