Forum Discussion
Import section of Excel Power Pivot (Data model) to Power Bi
Chan_tal ,
There are two commands in Power Query that you can use Remove Columns or Remove Rows and Merge or Append Querys. You will find both on the Home tab.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel
Hi Nathaniel_C,
Yes, I could delete the columns in Power Query, but then there are still available.
An user could always rollback and see the data.
I need a solution where the data will never enter Power Bi.
So therefore I would like to remove the column before the data is entering Power Bi. Do you know a solution?
Kind regards,
Chantal
- Nathaniel_C7 years ago
Community Champion
Chan_tal ,
Good point. How about duplicate your table in Excel, then delete the columns, then import. In Power Query you can reference a table, so it keeps up with the refresh not sure about Excel.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel