What .pbix file contains in direct query and live connection modes?

[seenukancharla]

Hi all,

             Iam very  new to powerbi.Can anyone please explain what  .pbix file contains when connection mode is direct query or live connection and also  for import  connection data stored in in-memory then  what about remaining like metadata and properties of power bi contents where these are stored for import  and direct query.Thanks in advance

Thanks &  regards

Seenu. 

[v-diye-msft]

Hi @seenukancharla ,

You can extract the pbix in depth , 3 connection move contains different files, also the size of the file indicate the data stored in the mode:

Report:  The report sheets, the placement of the visuals and all of their related properties

DataMashup File: The DataMashup file contains all of your Query Editor information.

DataModel File: The DataModel file is the file that actually stores all of your data in a highly compressed format.

DiagramState File: The DiagramState file  stored the information for the Table and Matrix locations.

Metadata: The Metadata file contains all the names with regards to what you see when in the Report View.

[seenukancharla]

Hi,

        Thank u that's really  helpful.And also can u please clarify this,is powerbi  uses  any cache memory  for  doing operations  in reports.If  yes  can u clarify  the cache memory  usage of powerbi reports.

Thanks & Regards

Seenu.

[v-diye-msft · Accepted solution]

Hi @seenukancharla ,

When you set up Import mode against a data source, almost full data copied and cached , that you can see the loading time is much more longer than other mode, but modelling the report is faster.

When you set up DirectQuery or live connection against a data source, the Power BI service will make live queries against the data source when users interact with report visuals. In addition, the service also keeps a cache for dashboard visuals created against the data source. This enables extremely quick loading of dashboards. Periodically, this cache is updated in a process called scheduled cache refresh.