Curbal
Curbal
  • 1 050
  • 18 707 342
Handling HTTP / API errors in Power Query | Return API errors instead of Power Query default ones
Join this channel membership to get access to all the recorded bites as they become available:
ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.htmljoin
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.html
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @ruthpozuelo@techhub.social
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
Переглядів: 1 563

Відео

Power BI Mini Master Class 1: Using a REST API as a data source
Переглядів 2,7 тис.14 днів тому
In this new course you will learn how to work with APIs in Power Bi. Check all the details here: curbal.com/course/power-bi-mini-master-class-1-using-a-rest-api-as-a-data-source Join this channel membership to get access to all the recorded bites as they become available: ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.htmljoin Here you can download all the pbix files: curbal.com/donwload-center SUB...
NOVEDADES de Power BI | Actualización de junio del 2024
Переглядів 1,5 тис.14 днів тому
Os interesaría que hiciera un video de las actualizaciones de Power BI en español? Este es un ejemplo. Join this channel membership to get access to all the recorded bites as they become available: ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.htmljoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! ua-cam.com/channels/J7UhloHS...
Summary features on Power BI update June 2024
Переглядів 3,9 тис.14 днів тому
Check out the new features in the June 2024 update for Power BI. Join this channel membership to get access to all the recorded bites as they become available: ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.htmljoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.html Our PLAYLISTS: - J...
Which platform is more popular: Power BI or Fabric? | Lets find out!
Переглядів 4,1 тис.21 день тому
We are finalizing the series by looking at the numbers and see if we can decide which one is more popular! Member series: ua-cam.com/play/PLDz00l_jz6zzkL2tcQvNY4M5OgDvqWLTl.html About logarithmic growth: ua-cam.com/video/dE1ShS_r_ms/v-deo.html&ab_channel=CurbalDataLabs Join this channel membership to get access to all the recorded bites as they become available: ua-cam.com/channels/J7UhloHSA4wA...
Change parameter ID to NAME dynamically in Power Query
Переглядів 2,5 тис.28 днів тому
Join this channel membership to get access to all the recorded bites as they become available: ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.htmljoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.html Our PLAYLISTS: - Join our DAX Fridays! Series: goo.gl/FtUWUX - Power BI dashboards ...
Make your text 💣 POP 💣in Power BI!!!
Переглядів 4,4 тис.Місяць тому
Formatting text in Power BI can be challenging, but it's possible with the right approach. Here's a step-by-step guide to enhance text formatting in Power BI: Additional html formatting options available in the blog post: curbal.com/curbal-learning-portal/make-your-text-pop-in-power-bi Format your text: www.w3schools.com/tags/tag_ul.asp#:~:text=The tag defines an,use the tag. Join this channel ...
Check out the new features for Power BI update May 2024 !
Переглядів 9 тис.Місяць тому
Lets go through all the updates on Power BI for May 2024. Join this channel membership to get access to all the recorded bites as they become available: ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.htmljoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.html Our PLAYLISTS: - Join our...
What to do and why Power Query won't detect data types correctly!
Переглядів 2,6 тис.Місяць тому
Have you been in the situation where you have a column with dates/numbers... but Power Query wont change the data type correctly? Lets explore why and how to fix it! Join this channel membership to get access to all the recorded bites as they become available: ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.htmljoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCRIBE to le...
The most important setting and probably most overlooked in Power BI...
Переглядів 13 тис.Місяць тому
Of the millions of settings available in Power BI if you dont get this setting right, changing it afterwards will become a nightmare and not changing it will also become a nightmare. You need to get this right from the beginning! Join this channel membership to get access to all the recorded bites as they become available: ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.htmljoin Here you can downloa...
BEST NEWS ever for Power BI business users!! There is a BUT though....
Переглядів 18 тис.Місяць тому
If you are a business user, rejoice!! Here is the best news this year for you. There is a but though.... Fingers crossed they reconsider! Join this channel membership to get access to all the recorded bites as they become available: ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.htmljoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCRIBE to learn more about Power and Exc...
DAX Fridays #228: PARTIAL text SEARCH with MULTIPLE values using DAX | 2 methods to solve it
Переглядів 2,6 тис.2 місяці тому
In this video I will show you how to do a partial text search of multiple values using DAX! Great DAX lesson to learn how to manage multiple values. I got asked to do this tutorial based on this power bi community thread: community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/partial-string-filter-based-multiple-selectedvalues/m-p/1523956 Join this channel membership to get access to all the r...
GORGEOUS cards in Power BI | Full tutorial for NEW CARD visual - Download 86
Переглядів 6 тис.2 місяці тому
Tired of your cards looking dull and ugly? Lets do a deep dive on the new cards visual ! The file is available in the community downloads folder , get file 85: curbal.com/donwload-center Join this channel membership to get access to all the recorded bites as they become available: ua-cam.com/channels/J7UhloHSA4wAqPzyi6TOkw.htmljoin Here you can download all the pbix files: curbal.com/donwload-c...
You will never do DRILLTHROUGH any other way in Power BI!
Переглядів 21 тис.2 місяці тому
You will never do DRILLTHROUGH any other way in Power BI!
NEW JOINS in Power Query! | Power BI update April 2024 (LeftSemi and Right Semi)
Переглядів 6 тис.2 місяці тому
NEW JOINS in Power Query! | Power BI update April 2024 (LeftSemi and Right Semi)
DYNAMICALLY highlight Power BI line chart | Power BI April update 2024
Переглядів 2,8 тис.2 місяці тому
DYNAMICALLY highlight Power BI line chart | Power BI April update 2024
DAX Fridays #227: Histogram of a measure (re-edit)
Переглядів 2 тис.2 місяці тому
DAX Fridays #227: Histogram of a measure (re-edit)
Exciting Power Bi April 2024 Updates And 2 Hidden Gems Revealed!
Переглядів 7 тис.2 місяці тому
Exciting Power Bi April 2024 Updates And 2 Hidden Gems Revealed!
Importing excel data in Power Query that contains errors
Переглядів 1,9 тис.2 місяці тому
Importing excel data in Power Query that contains errors
Find and tag duplicate values in Power Query
Переглядів 4,5 тис.3 місяці тому
Find and tag duplicate values in Power Query
Power BI update summary March 2024 - for busy people
Переглядів 6 тис.3 місяці тому
Power BI update summary March 2024 - for busy people
Create a SUMIF in Power Query and keep all columns
Переглядів 5 тис.3 місяці тому
Create a SUMIF in Power Query and keep all columns
DAX Fridays! #226: PREVIOUS DAX Function | Visual Calculations
Переглядів 1,7 тис.3 місяці тому
DAX Fridays! #226: PREVIOUS DAX Function | Visual Calculations
Export Power BI data to a SharePoint list
Переглядів 7 тис.3 місяці тому
Export Power BI data to a SharePoint list
DAX Fridays #225: RUNNINGSUM | Visual calculation functions
Переглядів 2,6 тис.4 місяці тому
DAX Fridays #225: RUNNINGSUM | Visual calculation functions
First look at visual calculations in Power BI!
Переглядів 4,9 тис.4 місяці тому
First look at visual calculations in Power BI!
Highlights of the Power BI update for February 2024.
Переглядів 4,9 тис.4 місяці тому
Highlights of the Power BI update for February 2024.
DAX Fridays #224: COLUMNSTATISTICS | A quick overview of your DAX model
Переглядів 2,1 тис.4 місяці тому
DAX Fridays #224: COLUMNSTATISTICS | A quick overview of your DAX model
Master The Art Of Mapping In Power Bi: How to easily create Line Maps!
Переглядів 5 тис.4 місяці тому
Master The Art Of Mapping In Power Bi: How to easily create Line Maps!
Unzip Any File Effortlessly In Power Bi Using This Enhanced Function!
Переглядів 3,9 тис.5 місяців тому
Unzip Any File Effortlessly In Power Bi Using This Enhanced Function!

КОМЕНТАРІ

  • @prolf2024
    @prolf2024 19 годин тому

    Ja ja ! Me había olvidado que eras española !! Pensé que era un fake !

  • @sameerulhaq4066
    @sameerulhaq4066 23 години тому

    but what if I have a large amount of data?

  • @KhantPatel-z1f
    @KhantPatel-z1f День тому

    if i deploy my dashboard into my website, how is an unknown person going to access the exported file

  • @giftcp82
    @giftcp82 День тому

    love this. Its awesome

  • @elijahd.spragueph.d8905
    @elijahd.spragueph.d8905 2 дні тому

    If only power query would perform calculations despite errors. I don't understand why having one error messes up the whole process.

    • @CurbalEN
      @CurbalEN 2 дні тому

      Sometimes it does, sometimes it doesnt. Havent figured out yet why sometimes it doesnt :( You can always add a “replace errors with” step to load the data regardless.

  • @lorejaime
    @lorejaime 2 дні тому

    hey! greetings from Colombia :D thank you so much for your help, I have been looking for a solution on how to hide empty rows and this was very helpful!!!

  • @sanj3189
    @sanj3189 3 дні тому

    Hi This will not work in the line charts then what is the approch i can change

  • @anjanathakur7076
    @anjanathakur7076 3 дні тому

    @Curbal : I have a situation where I want to Set slicer value selected to a default value , but show other values also in dropdown on that slicer based on selection of another slicer

  • @sameerulhaq4066
    @sameerulhaq4066 4 дні тому

    how to make it automatically detect the row ID and system time and datae and user email. I just want them to add comemnts and they cant edit the date time, email or row ID?

  • @notorioussamurai1671
    @notorioussamurai1671 4 дні тому

    If I do this, it would not make links clickable right? It only keeps simple text with proper visual order?

    • @CurbalEN
      @CurbalEN 3 дні тому

      You can make the text clickable if you transform the field to a webURL

    • @notorioussamurai1671
      @notorioussamurai1671 3 дні тому

      @@CurbalEN But I want the transformation to be automatic once a week, is it still possible?

  • @ashishpawar8416
    @ashishpawar8416 4 дні тому

    Thanks

  • @ThGrum
    @ThGrum 4 дні тому

    Hello all, I know I'm a bit late with this hint but you can show all rows by clicking in the bottom bar where the message shows that the data set is based on the first 1000 rows and then choose the complete data set.

  • @erinfield1943
    @erinfield1943 4 дні тому

    Ahhh I'm so excited to try this!!

  • @lolalola8421
    @lolalola8421 4 дні тому

    Excellent video!! What should I do if the category Id are not incremental by 1 and they don't have an uniform incremental? Thank you!!

  • @ilhanertan
    @ilhanertan 4 дні тому

    Just the thing I need!

  • @user-bt6we1rx6x
    @user-bt6we1rx6x 5 днів тому

    how to get the code in notepad?

  • @christimbers2006
    @christimbers2006 6 днів тому

    The STUPID thing about this is that in the US weeks don't actually start on a Sunday. The calendar is built around old christian principles and Sunday has been a day of rest for all of history for the whole of the world!

    • @CurbalEN
      @CurbalEN 6 днів тому

      🤷‍♀️🤷‍♀️🤷‍♀️

  • @nafeesahmed2642
    @nafeesahmed2642 7 днів тому

    Thank you for showing this. But I get the error stating - "This field was deleted from the model and can't be used as filter" in the filter pane, but I have this field- available in the model. Can you help?

  • @powerbinareal
    @powerbinareal 7 днів тому

    Fico impressionado como um vídeo de 6 de jan. de 2017 não perde sua importância com o tempo. Sempre Estou reaprendendo com vc. Valeu!!! 😎😎😱😱😱😱😱😱💪🏼💪🏼

  • @SarahTran1240
    @SarahTran1240 8 днів тому

    That's amazing. Your are a life saver.

  • @pmo4325
    @pmo4325 8 днів тому

    Soy profesional de Power BI y estudiante de espanol. Por eso me gusto mucho el video!

    • @CurbalEN
      @CurbalEN 8 днів тому

      Doble ganancia!

  • @John-bo2ut
    @John-bo2ut 8 днів тому

    Thank you

  • @CurbalEN
    @CurbalEN 9 днів тому

    Here is how you rename columns in Power Automate: ua-cam.com/video/lWu4n-ODe4U/v-deo.html&ab_channel=Curbal

    • @hemalvachani3723
      @hemalvachani3723 8 днів тому

      Great Thank you. Your content is helpful.And thanks for replying.😇

  • @hemalvachani3723
    @hemalvachani3723 9 днів тому

    @curbal - Even i have same issue - I only have the standard options of First Table Rows, Body, and Rows. Can you please help how did you got [sales]?

    • @CurbalEN
      @CurbalEN 9 днів тому

      Here is how you rename columns in Power Automate: ua-cam.com/video/lWu4n-ODe4U/v-deo.html&ab_channel=Curbal

  • @loub7398
    @loub7398 9 днів тому

    What type of job do you do that you get to use these skills? Thank you

    • @CurbalEN
      @CurbalEN 9 днів тому

      I am a Power BI consultant

  • @ryanclark3527
    @ryanclark3527 9 днів тому

    Tried this again, filters don't appear to work with this method.

  • @Srivatsa224
    @Srivatsa224 9 днів тому

    Hi, thank you for this video. I'm interested in getting to know more about the trending playback feature and how you've built that visual, could you please upload the PBI file in the Google cloud link in the description? I was not able to find it 😅

  • @bboykaze9538
    @bboykaze9538 9 днів тому

    I'll try this one ! Currently I use try function, it work very well but for some data it may slow down my report idk why " try _myAPIcall_ otherwise _myAPIcallWhereImSureThereIsNoError_" When doing this I'm sure that there will have no error due to error api response

    • @bboykaze9538
      @bboykaze9538 9 днів тому

      I use this function because all line have to call api endpoint filtering on cell's values. And then I expand the response

    • @CurbalEN
      @CurbalEN 9 днів тому

      All apis are different, so it is impossible to find a solution that fits all. It is good to have all this tricks to try which one suits best!

  • @sn3ider
    @sn3ider 9 днів тому

    This is great! Thank you for sharing!

  • @neelamnainiwal6711
    @neelamnainiwal6711 11 днів тому

    Can anybody help why my formula is not correct? Day 9 =AVERAGEX ( FILTER(Orders, Orders[ShipName] = "Romero y tomillo"), [Total Sales] )

  • @shubhamjain2423
    @shubhamjain2423 11 днів тому

    thank you very much, you saved my day. Amazing work!

  • @DimDims13
    @DimDims13 11 днів тому

    on some value its showing 2 M instead of 200 M..

  • @ankitmehrotra6104
    @ankitmehrotra6104 12 днів тому

    No such Extension Exists now .

    • @CurbalEN
      @CurbalEN 12 днів тому

      There are others , just google it :)

  • @marcosgarrido3452
    @marcosgarrido3452 13 днів тому

    Muchas gracias. Encantado de escucharte

  • @nomad9296
    @nomad9296 13 днів тому

    Hi better than the std drill through. OK when accessing an app directly in the service but if you access power bi throught Teams ive found URLs navigate you out of teams and opens in your browser thanks

    • @CurbalEN
      @CurbalEN 13 днів тому

      Yeah, hacks are like that, they kind of work but with limitations. I hope MS implements this !

  • @pedroportella3134
    @pedroportella3134 13 днів тому

    Where do I get that course?

    • @CurbalEN
      @CurbalEN 13 днів тому

      Here: curbal.com/course/power-bi-mini-master-class-1-using-a-rest-api-as-a-data-source

  • @macshock632
    @macshock632 13 днів тому

    Cool! But what if I need to keep a certain filter. I do not want to remove all.?

  • @abhijeetghosh27
    @abhijeetghosh27 14 днів тому

    Lovely... This would be very informative. 👍

    • @CurbalEN
      @CurbalEN 13 днів тому

      The course is available in the website curbal.com

  • @Im_Thanos
    @Im_Thanos 14 днів тому

    Wow.. that would be a great learning for us and from a master like you ..!!🙇🏽‍♀️ Looking forward for it..

    • @CurbalEN
      @CurbalEN 14 днів тому

      It is live at curbal.com :) Check the description box in the video

  • @ali.jawwad
    @ali.jawwad 14 днів тому

    Short and concise

    • @CurbalEN
      @CurbalEN 14 днів тому

      That is how we like it around here :)

    • @ali.jawwad
      @ali.jawwad 14 днів тому

      @@CurbalEN so much more to learn from you 👍🏻

    • @CurbalEN
      @CurbalEN 14 днів тому

      @ali.jawwad ❤️

  • @EncontroLegionarioOficial
    @EncontroLegionarioOficial 14 днів тому

    Hi, Is this matrix design a background image? :)

  • @KsrikYT
    @KsrikYT 14 днів тому

    Hi ma'm.. First of all i would like to thank you for all your knowledge sharing and videos. For 150k+ records i am able to process by this video, however i am facing issue with 850k+ records on production environment. Requirement is, end users want all data into a single csv file. Issue: By following the above steps , before creating a file we are doing append to a string variable right!!, there i am facing issue as string limit has reached showing a below error: The variable 'appendCSV' has size of more than '104937539' bytes. This exceeded the maximum size '104857600' allowed. Can you please suggest me please what actions i need to approach here to fix this. Thanks in advance.

  • @adrianjliu
    @adrianjliu 15 днів тому

    Hi Ruth, thanks so much for this very interesting analysis. I was lucky to have been able to meet Patrick, Phil, and other members of the Fabric CAT team (formerly Power BI CAT) in person here in Australia in April. My key takeaway is that Power BI is part of Fabric and Fabric is nothing without Power BI. Patrick said a few times that Power BI is Fabric. I think you can see from all of the recent content in Microsoft's official (and not so official) UA-cam channels where the future of data and BI at Microsoft is headed. Again, thank you for posting this as it does show the level of interest and discussion amongst the community.

    • @CurbalEN
      @CurbalEN 15 днів тому

      Thanks for sharing!

  • @MeIrritaIsso
    @MeIrritaIsso 15 днів тому

    You are incredible!

  • @user-uc2cq8vp9n
    @user-uc2cq8vp9n 15 днів тому

    Increible! sorprendió mucho

  • @arossi901
    @arossi901 15 днів тому

    Thank you very much! My report in PowerBi works correctly with 3 soap data sources, however the data update only works locally with PowerBi desktop, when I publish the report I have not found a way to have an update via gateway when one wants as for the other reports, I can schedule it but it is not on request Is there a way to do it ? The correct behaviour shoul be the same of a report with direct query through gateway thanks

    • @CurbalEN
      @CurbalEN 15 днів тому

      Web queries require a personal gateway :(

    • @arossi901
      @arossi901 15 днів тому

      @@CurbalEN With other PBI reports I use the Microsoft On-premises data gateway, this gateway works for direct query (update on the spot when user ask it) and import (update scheduled in the semantic models). What could be a personal gateway for replicate the update per request with a Soap data source ? I could write something in c# that every 5 minutes push data in a msql table or directly with msql server a stored procedure that take the data from soap for store it in a table. What do you suggest ?

    • @CurbalEN
      @CurbalEN 14 днів тому

      @arossi901 absolutely, you can also push to a pbi dataset: powerbi.microsoft.com/it-ch/blog/push-rows-to-a-power-bi-streaming-dataset-without-writing-any-code-using-microsoft-flow/

  • @2013Nicomusic
    @2013Nicomusic 15 днів тому

    Hello Curbal, i can´t see he function in the Marks blog. Could you upload it to some repository?

    • @CurbalEN
      @CurbalEN 15 днів тому

      Try this one instead, is more robust: m.ua-cam.com/video/47xHUsbBDnQ/v-deo.html

  • @mrNikkky
    @mrNikkky 15 днів тому

    Is shopify as a datasource will be implemented?

  • @MrSssscccc
    @MrSssscccc 15 днів тому

    You scored 6 on 5🎉, very nice explanation. Keep in driving us in the smartest way of consolidations...

  • @johnlhaase
    @johnlhaase 15 днів тому

    Hello I am trying to use power query to join/merge two table based on a sequence number string but not all. For example I have two columns in separate tables Ticket Number contains a 14 character string 00106480803209 and a Revised Ticket Number which has only 10 characters 648080320. The 10 characters are the same sequence by dropped the first 4 and last character. I would use extract range but the data is not consistent, just the sequence of 10 characters. Can power query match these two data sets?