Last answered:

21 Sept 2023

Posted on:

20 Sept 2023

0

Resolved: excel - power bi

In Power bi , I want to pull data from Excel, but I want it to be interactive so that if any change occurs in the data in Excel, it changes automatically in Power BI. What is the correct way to do that, please?

1 answers ( 1 marked as helpful)
Instructor
Posted on:

21 Sept 2023

1

By simply refreshing the dataset, given that the Excel file has got the exact same name, is saved in the exact same location and has the exact amount of columns. Otherwise you need to manually edit it inside Power Query every time you want to parse a new Excel file.

Submit an answer