Catching REFRESH ERRORS | Auditing Queries in Power BI

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

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

  • @narendrababu2287
    @narendrababu2287 3 ปีที่แล้ว +5

    For excel files this is seems perfect. What if we had errors with tables from import or direct query from a data base?

  • @ramonillarramendi3191
    @ramonillarramendi3191 9 หลายเดือนก่อน

    Wonderful. Thank you so much. And greatly explained as usual.

  • @saloua-el3cu
    @saloua-el3cu 6 หลายเดือนก่อน

    this is absolutly amazing !! thank you for sharing

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

    WoW! Thank you so much, extremely helpful! Amazing solution and clear explanation! Thanks again!

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

      Hi Jola! Thank you for the kind words much appreciated and super happy to hear its helpful :)

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

    Hello bas
    I have a date slicer and bar chart.
    Now if I select the custom range for example (april 7 - april 29) it should show as days in x axis if we select 1 month of custom date (may 15- June 15) then it should show as months. Like wise for years.
    Is this possible?

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

    Thank You
    BAS: Is there a way to connect a excel data from Desktop to PowerBI online?
    I have an excel report which will be updated on every week, what i am doing now is updating the data in the excel open PowerBI desktop refresh my report and then publish the report to the workspace.
    Rather i want to connect the Excel report directly into my PowerBI online. Please provide some tips

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

      Put the Excel file in One Drive.

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

      as TainuiaKid1973 suggests or create a data set in power bi service (for now copy paste, excel will be added soon)

  • @ryandimaiwat3180
    @ryandimaiwat3180 28 วันที่ผ่านมา

    I am having issue for the refresh. I just update the data and it doesnt updating the new data in the power bi .

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

    Hi Can anyone help with the error message (" [Expression, Error] The key didn't match any rows in the table") I am getting while running the power query? Basically, I have a Power Query appending 19 Excel files from a folder but sometimes when I am refreshing the data the files may be in use by users and this error message will pop up.

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

    Thanks for sharing great content!! 👏

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

    Awesome Bas!! Thank you for amazing video

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

    May be a video on how create your videos
    Really unique ..

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

    Hi @How to Power BI - do you know any solution to fix refresh errors linked to blank files?
    My data set is located in a SharePoint which contains multiple JSON files. Every once and then a blank JSON file is created. When I try to refresh my dashboard an end of buffer memory error occurs.
    For now, the solution that I found is to manually delete the affected files in the server - but this is not very convenient. I am wondering in there is any way to instruct Pbi to skip blank files?

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

    How to know where the error is, when we have so many columns and rows? Is there a way to find the errors without navigating the query?

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

    Can we include the wrong data type? how do we do that?

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

    Thank you. Further, the email should have a (paginated) report containing the error details sent to respective file owners.

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

    Thanks for the amazing video!!! The download link is not working

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

      thank you!! I've added the link 🙂

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

      @@HowtoPowerBI Thank you so much Bas!!! 😊

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

    Very, very nice.

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

    Thank you

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

      thx for watching!!! 😀

  • @Prashantpatil-cq3yt
    @Prashantpatil-cq3yt 3 ปีที่แล้ว +1

    Sir please ask subscribers for their problem and scenarios which they are facing when developing reports...
    So most of them will tell you about their problems and scenarios so you can make videos on solving that problem...
    So more the content, more the comments and more the views as well subscribers....
    Because you have much expertise in DAX...
    Thanks
    I mean to start doubt clearing video series...
    And put it the pbix file along with that video... So it will also useful

  • @SocialMedia-io1tz
    @SocialMedia-io1tz 3 ปีที่แล้ว

    I want to create dashboard which will show success and failure status of powerbi Dataset without going to Dataset

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

      then I hope this video will help you 🙂

  • @tebuny1
    @tebuny1 8 หลายเดือนก่อน

    Amazing… but 😵‍💫

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

    I have no idea what he is saying

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

    Amazing content! Thanks for sharing!!