Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
collinq
Super User
Super User

When I delete a column from a Query - is that BEFORE or AFTER the Refresh from then on?

I am not able to clarify how this works.  I add a table/Query to my Power BI Desktop.  There are 100 columns of data.  I go into Query and I delete 25 of those columns since I will never ever use them.  The next time I open this pbix file (and/or next time I refresh) does the system load all 100 columns and then remove the 25 or does it just load 75 columns from the start?




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




2 ACCEPTED SOLUTIONS

Thanks again Hasan,  that is what I was wondering!




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




View solution in original post

4 REPLIES 4
Hasan
Resolver I
Resolver I

Once you deleted the columns they will not see them unless you re add that table to your query

Thanks Hasan, I guess what I am asking though is whether or not it LOADS or not - basically, does it help me to delete them from an initial performance perspective?




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




does noot reload

Thanks again Hasan,  that is what I was wondering!




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.