[EN] [Power BI Lesson #10] Everything about Incremental Refresh over Databases and Files (CSV, XLSX)

แชร์
ฝัง
  • เผยแพร่เมื่อ 9 พ.ย. 2024

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

  • @Crossfire-fd8gy
    @Crossfire-fd8gy ปีที่แล้ว

    You are master! Thank you so much! I cant find info about incremental refresh when u have excel files in folder a long time. U saved my time.

  • @decentmendreams
    @decentmendreams ปีที่แล้ว

    You are amazing bro. I have been searching for this solution forever. I was very skeptical at first since everyone just discourages us not to try if there is no query folding . This works fantastic and now I can start redesigning my tables. One thing I am not sure is how an appended or merged table works with IR. I had a few failures when I practiced on this and not exactly sure but I suspect it has to do with it. Many thanks for the Eureka moment.

  • @lukeminikoski
    @lukeminikoski 3 ปีที่แล้ว +1

    I liked this class, opened my mind to a lot of things I cannot imagine just reading docs in Microsoft. Thank's

  • @Steve-kx9em
    @Steve-kx9em 3 ปีที่แล้ว +1

    Just wanted to say thanks for the great video, really got me out of a hole! Subbed.

  • @adekayodeekanola45
    @adekayodeekanola45 3 ปีที่แล้ว

    Ekanola watching from Nigeria.

  • @Petrj25
    @Petrj25 2 ปีที่แล้ว

    Thanks a lot, it grate solution

  • @kadirkkkk
    @kadirkkkk 2 ปีที่แล้ว

    Video is very helpful. Thank you.
    Now i also need incremental refresh of the referenced tables of the original inc.ref. table.
    You know sometimes i need and aggregation table or sometimes i need to combine different data from different sources.
    But as i see from my research the referenced tables make a full refresh from inc.ref. set tables :(

  • @midhunkumar1499
    @midhunkumar1499 3 ปีที่แล้ว +1

    Simply super

  • @shilpamahajan1838
    @shilpamahajan1838 3 ปีที่แล้ว

    It’s super helpful

  • @nitishranjan1716
    @nitishranjan1716 3 ปีที่แล้ว +1

    Thanks for your in depth knowledge and teaching it helps a lot for enhancing our skills.
    Also I want more depth knowledge in End to End Power BI...if you can advice on this.

    • @Xperiun_
      @Xperiun_  3 ปีที่แล้ว

      I have a complete course that I will offer in June.

    • @nitishranjan1716
      @nitishranjan1716 3 ปีที่แล้ว

      @@Xperiun_ Thanks for notifying. I can opt a course which comes in [EN].

    • @Xperiun_
      @Xperiun_  3 ปีที่แล้ว +1

      @@nitishranjan1716 sign up here: powerbiexperience.com/en/waitlist-course/

    • @nitishranjan1716
      @nitishranjan1716 3 ปีที่แล้ว

      @@Xperiun_ Also if any platform where we can post our problems or difficulties. I also attended your EN classes n a member of your telegram grp.
      Thanks

  • @alisahib8593
    @alisahib8593 3 ปีที่แล้ว

    Very informative video.
    Can you please make a video on " how to handle deletion in incremental refresh in power bi".
    I know in TH-cam have some videos on it but I like your way of teaching please create a video on it ASAP.
    I will be very thankful to you.
    God bless you
    Regards.

  • @satellitepop
    @satellitepop 3 ปีที่แล้ว

    Very good live.

  • @sallymahmoud9022
    @sallymahmoud9022 3 ปีที่แล้ว +1

    Thanks alot the information is super helpful can I ask on some cosmetic question 😊 where can I find the amazing backgrounds that you have in your dashboards?

  • @fernandoscuizato5
    @fernandoscuizato5 3 ปีที่แล้ว +1

    Nice English!!

  • @mohamedabbas2337
    @mohamedabbas2337 3 ปีที่แล้ว +1

    Mohamedabbas from Tanzania

  • @lmdelcon
    @lmdelcon 2 ปีที่แล้ว

    Hi Leonardo, awesome explanation and very useful. I have a question and appreciate your help about how to make incremental refresh using Sharepoint. There´s one section of video (after minute 43:45) when you use excel source and select just 1 file. But using Sharepoint, what´s the way to do it? Thanks!!

  • @picious
    @picious 2 ปีที่แล้ว

    thank you for this video , one question though . I have configured the incremental refresh having as souce some csv files (monthly files) BUT i get Duplicates because for example this month file (July) will have 2 weeks of July data and 2 weeks of June Data (previous month) because the source file (which I export the csv every week) has a 40 days data. I tried to "Remove Duplicates" in the Query Editor but that doesn't work,, any help, ideas? thank you again

  • @MazharShakeel
    @MazharShakeel 3 ปีที่แล้ว

    Hi!
    What is the brand or product name of the mic you are using @Leonardo Karpinski? :)

  • @esraagamal8938
    @esraagamal8938 3 ปีที่แล้ว

    Thanks a lot , but materials not have lesson number 7

  • @012yatin
    @012yatin 3 ปีที่แล้ว

    Can we use Incremental Upload for .xlsx files uploaded from FOlder?
    Can you please help me on this

  • @Travelblogwith_Rajat
    @Travelblogwith_Rajat ปีที่แล้ว

    Can you please let me know how to load future records like next 5months record using incremental refresh.

  • @maheshprasad-yk8bh
    @maheshprasad-yk8bh 3 ปีที่แล้ว +1

    Hello sir

  • @Travelblogwith_Rajat
    @Travelblogwith_Rajat ปีที่แล้ว

    Hi

  • @musharraf6446
    @musharraf6446 3 ปีที่แล้ว

    Sir I want to take your paid course but please release your paid course in English or if you already released pls share the link

  • @AmitMishra-jc5ry
    @AmitMishra-jc5ry 3 ปีที่แล้ว

    I have schedule error in power bi. I have published a report with incremental refresh and schedule a refresh time on daily basis. Incremental refresh running for some days but after some days it failed and show below error--
    The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
    If any one have solution please let me know.