Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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
You will have to press refresh button in Home menu to refresh the queries thus the visual.
But how do i connect my excel to powerbi sir?
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