Connecting Excel to Power BI

[stefans124]

Hello there, i have an issue regarding excel and powerbi. I have a task to basically connect an excel sheet to powerbi so that, for example, i can edit the data in the excel sheet, and that information will automatically update on powerbi. To give a better idea - i am editing the sheet on my laptop, while on the big tv, where there is powerbi turned on, the visualizations change as i change the tables in my excel. Can anyone help me with this? I hope my explanation was atleast somewhat understandable.

[Vijay_A_Verma]

You will have to press refresh button in Home menu to refresh the queries thus the visual.

[stefans124]

But how do i connect my excel to powerbi sir?

[Vijay_A_Verma · Accepted solution]

Under Home menu, you will see Excel workbook - Press it - Now select the required Excel

You can also watch this video - https://www.youtube.com/watch?v=LOnXePDb2hQ