ODBC connection via Power Query

Answers

• 

  

  0

  Sign in to vote

  Hi Paul,

  Power Query does not support direct import data from ODBC connections, it's a product limitation currently. I found it very hard to give you a certain answer why Power Query doesn't support ODBC connection. But you can open a discussion in Power Query forum, maybe the Power BI product team will give a resonable explanation for this issue.
  Power Query: http://social.technet.microsoft.com/Forums/en-US/home?forum=powerquery

  Here is a similar thread about this topic for your reference, please see:
  http://social.technet.microsoft.com/Forums/en-US/671fc151-c681-4c1c-825c-a74ca2ab4237/connect-power-query-to-existing-excel-data-connection?forum=powerquery

  Regards,

  ---

  Elvis Long
  TechNet Community Support

  

  • Marked as answer by Paul Levchuk Thursday, July 3, 2014 9:07 AM

  Thursday, July 3, 2014 6:16 AM