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
    10 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

     

CahabaData's avatar
CahabaData
Memorable Member
10 years ago

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.

 

 

  • DAT_Research's avatar
    DAT_Research
    New Member
    10 years ago

    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.

    • 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.