Forum Discussion
Cannot connect ODBC
I recently downlaoded 32-bit Power BI Desktop and I am only able to load Excel, Access, Web and Google Analytics data. I cannot connect to the ODBC SQL server to retrieve data. When I try to connect to ODBC or Analysis Services thee software locks up and must be force ended using task manager. I also am not givent the option to identify the server location I.P. Is there some setting I must change?
Thank you
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
10 Replies
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 YuThis solved the problem. Thank you very much for your help
DAT_Research have you tried setting up DSN and using that instead straight away using ODBC driver within power bi.
We do have one setup already but it seems Power BI is not recognizing it.
is the SQL Server 64 bit install? I ask because I downloaded/installed Power BI 64 bit - and am not able to connect to Access tables because the install of Office is 32 bit..... however if I export the Access tables to excel - I am able to import the excel files.
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.
