connect Excel to power Bi - Power Query

[Anonymous]

Dears,

Greeting

I have a power query in excel with applied steps

Now, I need to connect the same power query from excel to Power BI with taking consider applied steps in excel

What do I want the file to do?

I want when filling data in the data source in the excel file then reflect automatically in power bi

How I do that?

Thanks,

[MattAllington]

There is no option for live links. If you have a query in Excel, then you need to trigger a refresh in Excel, materialise the table into a sheet and save the file, then refresh PBI. Alternatively you may be able to move the query to PBI and only use Excel for data entry. You will still have to save the file (or course) but you won't have to trigger the query refresh in Excel. In PBI.com you can then refresh on a schedule, or presumably you could use Power Automate to detect the change in the Excel file and trigger a refresh. 

[Anonymous]

Thank you, Mr.Matt

Yeah, of course, IF I want to use excel only data entry and import data in PBI is a method (create new PQ in PBI) but I was already designed in excel power query (big data with modifications) wherefore I need a way to move power query in excel with "modifications" to design a dashboard in PBI .. what I need is when I filing data in excel & click refresh is reflected automatically in PBI dashboard.

[Jimmy801]

Hello @Anonymous 

why you don't transfer the power query code from Excel to Power BI and use in case Excel to read the data you entered there? So whenever you go to power BI the data is read from your original data source and from Excel, and thats it? Or I'm missing something?

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy