Forum Discussion

DAT_Research's avatar
DAT_Research
New Member
10 years ago
Solved

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 connec...
Need Help
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    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

     

ontario234's avatar
ontario234
Helper I
9 years ago

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.

DAT_Research's avatar
DAT_Research
New Member
9 years ago

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.

  • ontario234's avatar
    ontario234
    Helper I
    9 years ago

    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

    • DAT_Research's avatar
      DAT_Research
      New Member
      9 years ago

      Sorry, I cannot answer that.  You might want to start a new thread on that.