Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
In a schema I have 200+ tables in SQL, approx. +5million records in it and I would want to import only top 100 records from all these tables into power bi desktop and create 200+ tables. Is there any possibility to do so?
Thanks
Shakeel
Hi shakeelsyed,
Click Advanced options-> input the sql statement to import top 100 records in every table.
Regards,
Jimmy Tao
Thanks Jimmy Tao,
I have tried that way but its only taking data from the last query and creating only one table with it. any other trick to do so?
Importing data with latest records - This post is really important ! It plays an very important role in our daily life in every type of business . whether it is small sacle business or large scale business.
here you get related inforamation with complete guigance here -
Acer Support
Try to Insert required field (Normally by Date) in Report level filter and use the Relative filter as input Top N = 100
Thanks for your quick reply!
in that case, I will be able to load only one table at a time, whereas I want to upload all 200+ table at once to avoid duplication of work.
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |