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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Chan_tal
New Member

Import section of Excel Power Pivot (Data model) to Power Bi

Hi, 

 

We've created our data model in Excel (with a lot of measurements) and now I would like to merge this data model with other data in Power Bi. The Power Bi rapport will be available for the entire company, therefore I'm not allowed to import the sensitive data into Power Bi.

 

Is there a solution to import data from Excel Power Pivot, but not every column?

Or even better: to create an aggregated table in Power Bi from the Excel Power Pivot data model?

 

Kind regards,

Chantal

3 REPLIES 3
Nathaniel_C
Community Champion
Community Champion

@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





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

Proud to be a Super User!




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

@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





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

Proud to be a Super User!




Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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

Top Solution Authors