cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
amir_tohidi
Helper I
Helper I

Create table from SQL query

Hello,

 

In the dekstop data model, is it possible to create a table using a SQL query?

 

I am unable to load the underlying tables (just keeps importing forever) so I want to try loading the same tables using a SELECT TOP 1000 * to see if that works.

 

BTW - I have done this in Excel PowerPivot successfully.

 

Thanks in advance...

1 ACCEPTED SOLUTION

@amir_tohidi Yes. Just connect to SQL, and click on the "Advanced Options" and the drop down will include an area for you to enter a SQL Query.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

2 REPLIES 2

@amir_tohidi Yes. Just connect to SQL, and click on the "Advanced Options" and the drop down will include an area for you to enter a SQL Query.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Thank you! So easy when you know how 🙂

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.