Connect Excel with Power BI Dataflows (How & Why)
Vložit
- čas přidán 10. 07. 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: / @qthedatalad
email: quentin.sweeney@gmail.com
#powerbi #powerbitraining #exceltips - Věda a technologie
Some reasons why you would bring a Power BI dataflow in Excel:
1 - Ad-hoc analysis for quickly querying data. That way you don't have to wait for load previews in power bi service
2 - Can leverage as a source for pivot tables to build financial budget models, commission models, supply chain models from one source of truth (best for a lot of manual adjustments)
3 - If you want to troubleshoot any changes in Excel Power Query before you push changes to live production
4 - Can leverage this live connection from a dataflow and send the file to a coworker who isn't as technical
5 - im sure there is some other reasons why that I haven't figured out yet :)
Great video!
In our organization, some users do not have Power BI Pro licenses, but all of them have Microsoft 365. The question is: Can they use Excel to connect to Power BI Dataflows even though they don’t have a Power BI Pro license?
Nice video!
Thanks!
Im curious: what level of PBI and Fabric subscription did you need to UPLOAD the dataflows into powerbi Service?
all that was needed to upload dataflows to service was the license type: power bi pro
Great, but i do not see the power platform in my Excel. Which options exists?
I would confirm with the dataflow owner if you have access to whatever workspace the dataflow is in