cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
seenukancharla Frequent Visitor
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 Team
Community Support Team

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
Community Support Team
Community Support Team

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
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 Team
Community Support Team

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
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors