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:

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Forum statistics

Threads
1,213,534
Messages
6,114,184
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top