Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

connect Excel to power Bi - Power Query

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     Wh...
Interesting Links
MattAllington's avatar
MattAllington
Community Champion
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    Jimmy801
    Community Champion
    5 years ago

    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