cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
eniX
Helper III
Helper III

PBI checks source file on every step

Hi,

 

I would really like to know how PBI works with imported files. All I know is that the data (or part of the data) is put in an internal column-oriented dataset. I'm wondering why Power BI has to check the source file every time, no matter what I am doing, i.e. groupby, new column, filter, saving changes in editor. I have loaded my data into pbi-dataset, why would I need to check the source file every single time?

At the moment I'm working with some "large" files (300MB+) and most of the time I just wait for Power BI to check the source files. I can't imagine you guys working in the same way, I must do something wrong. Please help^^

1 REPLY 1
v-chuncz-msft
Community Support
Community Support

@eniX,

 

To have Query Editor apply the changes to the data model into Power BI Desktop, you need to select Close & Apply from Query Editor's File menu. Data View helps you inspect, explore, and understand data in your Power BI Desktop model. It's different from how you view tables, columns, and data in Query Editor. With Data View, you’re looking at your data after it has been loaded into the model.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors