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 all,
I have a SQL connection, this gives 518 columns and 23.000 rows. I only need about 40 columns..
What is the best way to avoid importing the 480 columns I do not need?
Solved! Go to Solution.
Hi! @IAM
There are 2 approaches that I follow and possible in the same order of choice if you can.
1) Get a view created for your table with the required column and then directly connect to that view. By creating a view you can also handle some of the transformations at the source level.
2) You can use a select statement with the column names and connect to the same table.
I hope it would make sense why to choose the 1st approach.
Hi! @IAM
There are 2 approaches that I follow and possible in the same order of choice if you can.
1) Get a view created for your table with the required column and then directly connect to that view. By creating a view you can also handle some of the transformations at the source level.
2) You can use a select statement with the column names and connect to the same table.
I hope it would make sense why to choose the 1st approach.
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.