Refresh Power BI Desktop Excel data

[jamalq123]

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

[v-huizhn-msft]

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