5 ways to export data from Power BI
Рет қаралды 2,815
Күн бұрын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/
@emilymorrison4263 Ай бұрын
Loved the live connected/refreshable table. Never knew that was possible.
@AccessAnalytic Ай бұрын
Cheers Emily!
@mnowako Ай бұрын
Excellent! Thank you!
@AccessAnalytic Ай бұрын
You’re welcome.
@Datavoll Ай бұрын
Great 🎉
@IvanCortinas_ES Ай бұрын
This is valuable information. Thanks Wyn, for providing all these options!
@AccessAnalytic Ай бұрын
Cheers Iván.
@kkravch Ай бұрын
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?
@AccessAnalytic Ай бұрын
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
@kkravch Ай бұрын
@@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?
@AccessAnalytic Ай бұрын
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.
Access Analytic
Рет қаралды 7 М.
Access Analytic
Рет қаралды 7 М.
Bulldog Analytics
Рет қаралды 5 М.
Access Analytic
Рет қаралды 2,2 М.
Access Analytic
Рет қаралды 80 М.
Maven Analytics
Рет қаралды 37 М.
Fabiosa Best Lifehacks
Рет қаралды 38 МЛН
Olivia Family
Рет қаралды 5 МЛН