Connect Excel with Power BI Dataflows (How & Why)
Channel: Q that Data Guy
Date: 27/02/2024

This is how to connect Excel with Power BI Dataflows and when this approach might be best for your needs. 

0:00 - guy from internet doing full screen intro fumbling words yaya
0:12 - scoping dataflow in powerbi service and verifying email address
1:10 - excel integration with powerbi dataflow table (standard table)
3:12 - tangent from personal experience on when this method is best used
4:02 - excel integration with power bi dataflow table using power query
5:56 - pivot table ur dataflow table with custom column we made
7:46 - lets set this puppy to auto refresh (lets not redo work ya?)
9:19 - how to access/edit power query again from excel
10:26 - closing thoughts thx for making it to this portion of the vid

if this helped, like or subscribe or ill eat ur cookies: https://www.youtube.com/channel/UCAqRboAoe3s5rgZDiYtSTsQ?sub_confirmation=1

email: quentin.sweeney@gmail.com

#powerbi #powerbitraining #exceltips