Forum Discussion
Can Power BI refresh a Power Query result
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.
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.
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.
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."