cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 254 members 2,711 guests
Please welcome our newest community members: