cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
seenukancharla
Frequent Visitor

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

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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

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.

 

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

View solution in original post

3 REPLIES 3
Highlighted
Community Support
Community Support

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

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:

Picture1.png

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.

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.
seenukancharla
Frequent Visitor

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

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.

Community Support
Community Support

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

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.

 

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

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors