×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

SQL View not available to Excel Power Query

SQL View not available to Excel Power Query

SQL View not available to Excel Power Query

(OP)
Excel 2016, SQL Server 2008 (not R2).

I created a view in SQL, then wanted to to use Power Query to analyze the data. I created a view because my SQL was too complicated to be displayed graphically, and it must be able to be displayed graphically in order to use parameters.

So I did all this and it works perfectly on my machine (which has SQL 2019). However when I tried to deploy it to the customer, the view is not available to Excel Power Query (the tables are there). I can query the view in SSMS no problem.

Is there a setting somewhere that excludes views from Power Query? Or is this a limitation of SQL 2008? Any insights appreciated.

Edit - I can also see the view in Crystal Reports, which reinforces my thinking that this is an excel setting.

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

www.gainfocus.biz/exceladdin.html

RE: SQL View not available to Excel Power Query

(OP)
SOLVED!

I downloaded the latest SQL Server Native Client ODBC Drivers and everything works perfectly.

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

www.gainfocus.biz/exceladdin.html

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close