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/
  • แนวปฏิบัติและการใช้ชีวิต

ความคิดเห็น • 11

  • @emilymorrison4263
    @emilymorrison4263 25 วันที่ผ่านมา +2

    Loved the live connected/refreshable table. Never knew that was possible.

  • @mnowako
    @mnowako 22 วันที่ผ่านมา +1

    Excellent! Thank you!

  • @IvanCortinas_ES
    @IvanCortinas_ES 25 วันที่ผ่านมา +1

    This is valuable information. Thanks Wyn, for providing all these options!

  • @Datavoll
    @Datavoll 23 วันที่ผ่านมา +1

    Great
    🎉

  • @kkravch
    @kkravch 24 วันที่ผ่านมา +2

    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
      @AccessAnalytic  24 วันที่ผ่านมา

      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
      @kkravch 24 วันที่ผ่านมา

      @@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
      @AccessAnalytic  23 วันที่ผ่านมา

      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.