Forum Discussion
Cannot connect ODBC
Hi DAT_Research,
I got the information internally which said the trending issue "When we click Get Data > All or some of the data source dialog might not appear or clicking a source such as SSAS or SQL may hang Power BI Desktop. And we have to use the task manager to kill the process/app." already fixed in the latest Power BI desktop version.
In your scenario, which version of Power BI desktop do you run? Please update it to the version 2.37.4464.602 to check if the issue has been solved.
If you have any question, please feel free to ask.
Best Regards,
Qiuyun Yu
I am not sure about eh SQL Server install but it accomodates my 32 bit install of Office just fine. In fact many of the SQL tales are linked to my access database for use and when I load those databases to PowerBI I can see the queries and tables I have built from the SQL links but I do not see the SQL linked tables themselves.
Hi, I ran into exactly same issue as yours. How did you fix yours? Could you please share? I am using the latest version of power BI desktop.
The link in the reply above worked for me. I believe I had mistakenly installed the 32 bit version when I actually needed the 64 bit version.
Thank you for replying. I have the latest 32 bit version on my 32-bit PC. I am able to connect to SQL server directly (via dsn, ODBC) and could load the tables. However, I need to load access database (that contains the tables linked to SQL server) as my queries are already built in there. Is there any way to this kind of acccess database in power BI? Thanks
Sorry, I cannot answer that. You might want to start a new thread on that.