cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jamalq123 Regular Visitor
Regular Visitor

Refresh Power BI Desktop Excel data

Dear All,

 

I am using excel to compile media industry data and then get into the Power BI Desktop through the normal procedure. After incorporating additional/ incremental information in the excel sheet then I have to refresh the Power BI Desktop so that my visualization could retain the latest info.

I have very huge data in MS Excel sheet, there are almost 700,000 rows and around 15 fields.

 

When I add only 15 rows in Excel sheet then every time I have to refresh the Power BI Desktop. It takes usually sometimes and effects the efficiency.

Can anyone please guide the efficient solution of this issue?

 

Regards,

 

Jamal Qamar

1 REPLY 1
Microsoft v-huizhn-msft
Microsoft

Re: Refresh Power BI Desktop Excel data

Hi @jamalq123,

If you want to refresh faster, please filter data and only load necessary data, instead of full data. Aside from that, there is no better way to refresh large amount of data from what I know.

The incremental refresh is unsupported in Power BI, please review the following feature request and vote them. I believe it will come soon. After then, you will refresh the data source efficiently.

Incremental data refresh and Incremental Data Loads

Best Regards,
Angelia

Helpful resources

Announcements
New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (3,111)