5 ways to export data from Power BI
ฝัง
- เผยแพร่เมื่อ 30 มิ.ย. 2024
- The team and I at Access Analytic develop Power BI and Excel solutions for clients in Australia and deliver training around the World. accessanalytic.com.au/
00:00 Intro
01:29 Bravo BI
02:42 DAX Studio
04:27 Analyze in Excel
07:24 Export Underlying Data
10:00 Live Table Summary
14:50 Paginated Report
bravo.bi/
daxstudio.org/
Marco's VBA edits
www.sqlbi.com/tv/consuming-a-...
Did you know I've written a book "Power BI for the Excel Analyst"?
pbi.guide/book/
Connect with me
wyn.bio.link/ - แนวปฏิบัติและการใช้ชีวิต
Loved the live connected/refreshable table. Never knew that was possible.
Cheers Emily!
Excellent! Thank you!
You’re welcome.
This is valuable information. Thanks Wyn, for providing all these options!
Cheers Iván.
Great
🎉
Thanks a lot. Can you link data to Excel's data model directly so the end user can use dax on local machine without using power query because of much data?
You can’t connect to a data model in a separate Excel file, but can create the table connection inside the same file as the model
@@AccessAnalytic Thanks. Actually.... I played with it and got it connected directly into data model form the BI table. I don't have power query at all but have a power bi connection to powerpivot. Is there any resource here to show screenshot?
So I’m not quite following. Are you connecting to a Power BI data model that lives in PowerBI.com or are you connecting to a Power Pivot data model that lives in a local Excel file.