Can PowerBI refresh the PowerQuery on my Excel data

mrchonginhk

Well-known Member
Joined
Dec 3, 2004
Messages
679
I have PowerBI connected to Excel data source (ie not imported but "linked").
This Excel (either can be on OneDrive business or desktop) contains a powerquery to do data transformation.

The data in Excel data itself is stored in "Data" tab that resides within this Excel and does not further get data externally.

The PowerBI get data from another tab which is a "Result" table of the powerquery in this Excel.

From time to time system would make changes to "Data" tab. There is a need to refresh the Excel's powerquery to update "Result".

My challenge here is, is it possible the PowerBI (desktop or web BI Service) to refresh the Excel's powerquery & the Result table and sync new result into Power BI ?
How ? Please help. Thanks.

And if PowerBI cannot do this, is there any way to refresh Excel powerquery for Power BI's consumption ?
I know moving Powerquery into PowerBI is one way, but if possible due to business nature we wish not to do so ...

Pls help.. thanks all...
 
Last edited:

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Watch MrExcel Video

Forum statistics

Threads
1,096,446
Messages
5,450,494
Members
405,614
Latest member
SJ789

This Week's Hot Topics

Top