Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
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...
Solved! Go to 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.
@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.
Thank you! So easy when you know how 🙂
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
71 | |
56 | |
38 | |
35 |
User | Count |
---|---|
85 | |
66 | |
59 | |
46 | |
45 |