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

Power Bi Scripting loading time

Hi Team,

 

Need help on power bi data loading .what's the correlation between row count and file size in power bi for loading the data .

example we have one reports data is 

2832921 rows taking 20 minutes to load the data . is there any specfic rule for loading the data depend upon the rows count.

Thanks in Advance.

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: Power Bi Scripting loading time

Hi @Shashankapowerb ,

 

If you are using the Import mode, th loading time depens on the size of your model (rows and columns), network status between pc and datasource, and also the performance of pc which runs the power bi. At last, calculated columns and calculated tables are computed during the database processing and then stored in the model, it will also increase the load time. You can follow this documents to optimize data model and reduse the load time.

 

Best regards,

 

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

Community Support Team _ Dong Li
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

Community Support Team
Community Support Team

Re: Power Bi Scripting loading time

Hi @Shashankapowerb ,

 

I tested a dataset about 670MB (AdvantureExampleData, ~50M rows), it took approx 15 - 20 minutes to load in Desktop, So if your dataset is as big as it, you may be should consider optimize the data model.

 

24.PNG

 

The reasons about load time can be the following:

1. Data Model (rows, columns, tables, you can follow this article to optimize the data model)

2. Hardware Performance (either be data source or computer running power bi desktop, check usage while importing to see if any one reach the bottleneck)

3. Network Performance(mainly when using gateway to imported into service, check the gateway bandwidth usage while refreshing)

 

Best regards,

 

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

Community Support Team _ Dong Li
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

4 REPLIES 4
Community Support Team
Community Support Team

Re: Power Bi Scripting loading time

Hi @Shashankapowerb ,

 

If you are using the Import mode, th loading time depens on the size of your model (rows and columns), network status between pc and datasource, and also the performance of pc which runs the power bi. At last, calculated columns and calculated tables are computed during the database processing and then stored in the model, it will also increase the load time. You can follow this documents to optimize data model and reduse the load time.

 

Best regards,

 

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

Community Support Team _ Dong Li
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

Shashankapowerb Frequent Visitor
Frequent Visitor

Re: Power Bi Scripting loading time

While we loading the data in power bi Desktop its taking 20 Minutes & when we will loading the same data through gateway taking too much time Approx 50 mins is there any specfic reason behind .

Community Support Team
Community Support Team

Re: Power Bi Scripting loading time

Hi @Shashankapowerb ,

 

I tested a dataset about 670MB (AdvantureExampleData, ~50M rows), it took approx 15 - 20 minutes to load in Desktop, So if your dataset is as big as it, you may be should consider optimize the data model.

 

24.PNG

 

The reasons about load time can be the following:

1. Data Model (rows, columns, tables, you can follow this article to optimize the data model)

2. Hardware Performance (either be data source or computer running power bi desktop, check usage while importing to see if any one reach the bottleneck)

3. Network Performance(mainly when using gateway to imported into service, check the gateway bandwidth usage while refreshing)

 

Best regards,

 

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

Community Support Team _ Dong Li
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

Shashankapowerb Frequent Visitor
Frequent Visitor

Re: Power Bi Scripting loading time

Thanks for quick reply .what's the correlation between row count and file size in power bi for loading the data .Power Bi Data laoding will depends on rows number/file size. Thanks in Advance.

While refreshing data through gateway taking too mcuh time as comapred to Desktop through manually .

Is there any spcifics rule why taking too much time in gateway

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
Top Kudoed Authors