topic Re: Can Power BI refresh a Power Query result in Power Query

Can Power BI refresh a Power Query result

Craig — Wed, 14 Apr 2021 15:03:44 GMT

Hello

In Excel Online one can not refresh a PowerQuery table of data. My client wants a PowerQuery table of data but to be able to refresh the table using a browser or HTML web page.

I know Power BI has Power Query built in. Can I use Power BI to take a table of Excel data, modify the table with Power Query commands, then show the outputi in PowerBI not as a chart but as a loaded query table (columns of data) and give the user the ability to refresh it on a web page?

thank you very much!

Craig

Re: Can Power BI refresh a Power Query result

lbendlin — Thu, 15 Apr 2021 23:29:48 GMT

The use case is not very clear. Are you referring to the newly announced "Analyze in Excel Online" feature that will come out "soon" ?

Re: Can Power BI refresh a Power Query result

v-kelly-msft — Fri, 16 Apr 2021 08:07:22 GMT

Hi Craig ,

I guess you can if your excel file is stored on-premise.Check the similar thread below:

https://sharepoint.stackexchange.com/questions/194429/unable-to-refresh-data-in-excel-online-connected-using-power-query

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Re: Can Power BI refresh a Power Query result

Craig — Fri, 16 Apr 2021 12:45:35 GMT

Yes, I have a neat Excel file using PowerQuery that refreshes just the way I want it. So when I click a drop down item, I just run Data Refresh All to the data below which is based upon what I pick in a drop down. here is a onedrive link to the file in case you want to see it: dynamic power query filter

But a top expert in Excel said you can not refresh using Excel online as my client needs to have it done in online using a webpage html format.

so I thought maybe do the Power Query work in Power BI which has Power Query built in and somehow get it to refresh when I click the drop down. But I send Power BI is all about visualizations not so much to refresh and show updated data from a list.

Appreciate any of your thoughts if it can be done with PowerBI

thank you very much

Craig

However, my client needs to see it run online or via an HTML web page. But Excel online can not refresh.

Assuming this feature "Analyze in Excel Online" will not come out anytime this spring, I need to show my client how to refresh the Excel data but do it online or via a web page.

Re: Can Power BI refresh a Power Query result

Craig — Fri, 16 Apr 2021 12:47:55 GMT

meant to say in my post above....

"But I sense Power BI is all about visualizations and not so much about how to refresh and show the updated data."

Re: Can Power BI refresh a Power Query result

lbendlin — Fri, 16 Apr 2021 16:43:58 GMT

I agree. While Power Query allows for extensive transforms, it does so exclusively to feed Power BI. It is not a fully featured ETL/ELT tool.

Re: Can Power BI refresh a Power Query result

Craig — Mon, 19 Apr 2021 19:07:34 GMT

thanks very much.

Re: Can Power BI refresh a Power Query result

Craig — Mon, 19 Apr 2021 19:09:23 GMT

thanks very much

i assume i can not refresh Excel online...the other post mentioned Sharepoint On premises might work but I dont have that

do you know when the new feature to make Excel online refresh will come out?

thanks

Re: Can Power BI refresh a Power Query result

lbendlin — Mon, 19 Apr 2021 20:29:34 GMT

I would hope that they will announce the timeline for that Excel Online refresh during next month's Business Application summit. That event is on May 4th, I believe.