Forum Discussion
Reducing data (columns) imported form Excel
Hi Anonymous ,
If the column name of the file does not change, the operation you thought before is right. What you do in the query editor is the first step in visualizing the data. When the data is refreshed in the future, as long as the column name does not change, the loaded data will not load the previously deleted columns.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
If the column name of the file does not change, the operation you thought before is right. What you do in the query editor is the first step in visualizing the data. When the data is refreshed in the future, as long as the column name does not change, the loaded data will not load the previously deleted columns.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks V-lianl-msft !
Does that mean that is I were to insert a 'Delete Other Columns' step as my fifth step in my sequence as shown above, this would lead to the deleted columns never being loaded in the first place when I upload to Power BI Service?
Hi Anonymous ,
Please try to do this. My test was successful a long time ago.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi Anonymous ,
Is this problem sloved?
If not, please let me know.Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.