Curbal
Curbal
  • Видео 1 050
  • Просмотров 18 662 361
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:
ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkwjoin
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkw
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....
Просмотров: 642

Видео

Power BI Mini Master Class 1: Using a REST API as a data source
Просмотров 2,3 тыс.17 часов назад
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: ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkwjoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCR...
NOVEDADES de Power BI | Actualización de junio del 2024
Просмотров 1,3 тыс.День назад
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: ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkwjoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! ruclips.net/channel/UCJ7UhloHSA...
Summary features on Power BI update June 2024
Просмотров 3,4 тыс.День назад
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: ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkwjoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkw Our PLAYLISTS: - Join ou...
Which platform is more popular: Power BI or Fabric? | Lets find out!
Просмотров 4 тыс.День назад
We are finalizing the series by looking at the numbers and see if we can decide which one is more popular! Member series: ruclips.net/p/PLDz00l_jz6zzkL2tcQvNY4M5OgDvqWLTl About logarithmic growth: ruclips.net/video/dE1ShS_r_ms/видео.html&ab_channel=CurbalDataLabs Join this channel membership to get access to all the recorded bites as they become available: ruclips.net/channel/UCJ7UhloHSA4wAqPzy...
Change parameter ID to NAME dynamically in Power Query
Просмотров 2,4 тыс.14 дней назад
Join this channel membership to get access to all the recorded bites as they become available: ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkwjoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkw Our PLAYLISTS: - Join our DAX Fridays! Series: goo.gl/FtUWUX - Power BI dashboards for be...
Make your text 💣 POP 💣in Power BI!!!
Просмотров 4,3 тыс.21 день назад
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: ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkwjoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkw Our PLAYLISTS: - Join our DAX F...
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: ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkwjoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCRIBE to learn...
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: ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkwjoin Here you can download a...
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: ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkwjoin Here you can download all the pbix files: curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel ...
DAX Fridays #228: PARTIAL text SEARCH with MULTIPLE values using DAX | 2 methods to solve it
Просмотров 2,6 тыс.Месяц назад
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 тыс.Месяц назад
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: ruclips.net/channel/UCJ7UhloHSA4wAqPzyi6TOkwjoin Here you can download all the pbix files: curbal.com/donwload-cent...
You will never do DRILLTHROUGH any other way in Power BI!
Просмотров 20 тыс.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,3 тыс.2 месяца назад
Find and tag duplicate values in Power Query
Power BI update summary March 2024 - for busy people
Просмотров 6 тыс.2 месяца назад
Power BI update summary March 2024 - for busy people
Create a SUMIF in Power Query and keep all columns
Просмотров 4,9 тыс.2 месяца назад
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,8 тыс.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,8 тыс.4 месяца назад
Unzip Any File Effortlessly In Power Bi Using This Enhanced Function!

Комментарии

  • @loub7398
    @loub7398 6 часов назад

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

    • @CurbalEN
      @CurbalEN 41 минуту назад

      I am a Power BI consultant

  • @ryanclark3527
    @ryanclark3527 7 часов назад

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

  • @Srivatsa224
    @Srivatsa224 13 часов назад

    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 14 часов назад

    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 14 часов назад

      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 12 часов назад

      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 17 часов назад

    This is great! Thank you for sharing!

  • @neelamnainiwal6711
    @neelamnainiwal6711 2 дня назад

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

  • @shubhamjain2423
    @shubhamjain2423 2 дня назад

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

  • @DimDims13
    @DimDims13 2 дня назад

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

  • @ankitmehrotra6104
    @ankitmehrotra6104 3 дня назад

    No such Extension Exists now .

    • @CurbalEN
      @CurbalEN 3 дня назад

      There are others , just google it :)

  • @marcosgarrido3452
    @marcosgarrido3452 3 дня назад

    Muchas gracias. Encantado de escucharte

  • @nomad9296
    @nomad9296 3 дня назад

    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 3 дня назад

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

  • @pedroportella3134
    @pedroportella3134 4 дня назад

    Where do I get that course?

    • @CurbalEN
      @CurbalEN 4 дня назад

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

  • @macshock632
    @macshock632 4 дня назад

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

  • @abhijeetghosh27
    @abhijeetghosh27 4 дня назад

    Lovely... This would be very informative. 👍

    • @CurbalEN
      @CurbalEN 4 дня назад

      The course is available in the website curbal.com

  • @Im_Thanos
    @Im_Thanos 4 дня назад

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

    • @CurbalEN
      @CurbalEN 4 дня назад

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

  • @ali.jawwad
    @ali.jawwad 5 дней назад

    Short and concise

    • @CurbalEN
      @CurbalEN 4 дня назад

      That is how we like it around here :)

    • @ali.jawwad
      @ali.jawwad 4 дня назад

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

    • @CurbalEN
      @CurbalEN 4 дня назад

      @ali.jawwad ❤️

  • @EncontroLegionarioOficial
    @EncontroLegionarioOficial 5 дней назад

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

  • @KsrikYT
    @KsrikYT 5 дней назад

    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 6 дней назад

    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) RUclips 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 6 дней назад

      Thanks for sharing!

  • @MeIrritaIsso
    @MeIrritaIsso 6 дней назад

    You are incredible!

  • @user-uc2cq8vp9n
    @user-uc2cq8vp9n 6 дней назад

    Increible! sorprendió mucho

  • @arossi901
    @arossi901 6 дней назад

    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 6 дней назад

      Web queries require a personal gateway :(

    • @arossi901
      @arossi901 5 дней назад

      @@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 5 дней назад

      @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 6 дней назад

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

    • @CurbalEN
      @CurbalEN 6 дней назад

      Try this one instead, is more robust: m.ruclips.net/video/47xHUsbBDnQ/видео.html

  • @mrNikkky
    @mrNikkky 6 дней назад

    Is shopify as a datasource will be implemented?

  • @MrSssscccc
    @MrSssscccc 6 дней назад

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

  • @johnlhaase
    @johnlhaase 6 дней назад

    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?

  • @matheussiedler
    @matheussiedler 6 дней назад

    What a great video! You really helped me with a project I'm developing. One more subscriber to the channel!

  • @christianhartgrove
    @christianhartgrove 6 дней назад

    THANK YOU!

  • @claroseduardo
    @claroseduardo 6 дней назад

    que hablas Español??????? qué más puedo pedir? aunque también admito que me gustaban tus videos en inglés para mejorar el mío, pero no deja de ser una grata sorpresa este video. Gracias por tu trabajo

    • @CurbalEN
      @CurbalEN 6 дней назад

      Soy española :)

    • @claroseduardo
      @claroseduardo 5 дней назад

      @@CurbalEN en ese caso, permite que pida ayuda sobre un tema recurrente en el que estoy un poco perdido: "Errores en actualizaciones de Flujos de datos en Power BI Services", ¿hay alguna forma de saber con exactitud que columna está fallando al intentar por ejemplo convertir un carácter en entero? Saludos desde Granada ES!

    • @CurbalEN
      @CurbalEN 5 дней назад

      Copiar el query en power bi desktop :) Saludos de una asturiana !

  • @emiliachauturewicz8141
    @emiliachauturewicz8141 7 дней назад

    Very useful function in that case :) Total Sales running total in Date desc = CALCULATE( [Total Sales], FILTER( ALLSELECTED('Date'[Date]), ISONORAFTER('Date'[Date], MAX('Date'[Date]), DESC) ) )

  • @alexrosen8762
    @alexrosen8762 7 дней назад

    Yes! Looking forward to it

  • @juliom6260
    @juliom6260 7 дней назад

    Thanks

  • @Massiminesta9568
    @Massiminesta9568 7 дней назад

    Amazing content! Looking forward!

  • @rodrigochavez7
    @rodrigochavez7 7 дней назад

    How many hours will have the course? This is the first course related to APIs that I have seen, really excited for that!

    • @juliom6260
      @juliom6260 7 дней назад

      1:08

    • @CurbalEN
      @CurbalEN 7 дней назад

      One hour. Perfect to get started!

  • @gulhermepereira249
    @gulhermepereira249 7 дней назад

    looking forward for that course! Thank you

  • @tracy2919
    @tracy2919 7 дней назад

  • @ashishchanchalverma5722
    @ashishchanchalverma5722 7 дней назад

    I cannot download this pbix file. Please help me to download

  • @atharshabuddin3812
    @atharshabuddin3812 7 дней назад

    Wow! That sounds great. Really excited for the upcoming course. Thank you.

  • @BarbaraCarolineFerreiradaSilva
    @BarbaraCarolineFerreiradaSilva 7 дней назад

    Hii, I'm still finding some problems in formatting my html table. I create a 'Compose' to format my table, but when I sent a email, my table is still no getting the format from the 'compose' style. Do you know why this still could be happining?

    • @CurbalEN
      @CurbalEN 7 дней назад

      Post the details on the powerautomate community. They should be able to help you!

  • @baskis69
    @baskis69 7 дней назад

    Que sea el primero de muchos¡¡

  • @sarajvo2010
    @sarajvo2010 7 дней назад

    Best content creator! Thx you

  • @rahupradhan1889
    @rahupradhan1889 7 дней назад

    Could you please make a video on " How to load data from SAP systems and SQL Data base " Please 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏❤❤❤

    • @CurbalEN
      @CurbalEN 7 дней назад

      I dont have access to any public SAP I could demo

    • @rahupradhan1889
      @rahupradhan1889 7 дней назад

      @@CurbalEN any idea from where I can find those content

    • @CurbalEN
      @CurbalEN 7 дней назад

      @rahupradhan1889 not sure , do a google search, something should come up

  • @kishanbhise4733
    @kishanbhise4733 7 дней назад

    What if i have 1000 different schools ?

  • @user-fz1ns1nd9t
    @user-fz1ns1nd9t 7 дней назад

    Good job but how can I get all other data like likes, dislikes, gender, location of viewers and subscribers how can I go about that thanks

  • @lukemanthuruthil2275
    @lukemanthuruthil2275 8 дней назад

    Can you do this without access to data source?

    • @CurbalEN
      @CurbalEN 8 дней назад

      I dont think so

  • @geineralbertomejiagarzon4034
    @geineralbertomejiagarzon4034 8 дней назад

    Que sea el primero de muchos vídeos más en español. Gracias por ello Ruth. 👍🏽

    • @CurbalEN
      @CurbalEN 8 дней назад

      Oido cocina! 😉

  • @danher4607
    @danher4607 8 дней назад

    Por favor, haz videos en español, tieen varios suscriptores de altinoamerica.

    • @CurbalEN
      @CurbalEN 8 дней назад

      Que os gustaria ver?

  • @edwardwernich9259
    @edwardwernich9259 8 дней назад

    I have been fighting this issue for 2 weeks now, using a different approach that didn't work. This solution is elegant and brilliant, thank you!!

  • @user-gi3wo5vz1m
    @user-gi3wo5vz1m 8 дней назад

    how did you get that background?

    • @CurbalEN
      @CurbalEN 8 дней назад

      I made it in figma

  • @TheAtulsachan1234
    @TheAtulsachan1234 9 дней назад

    This is how I did it AverageOrdersize = VAR temptable = SUMMARIZECOLUMNS( Orders[CustomerID], Orders[OrderID], "Count of Products",COUNT(Orders[ProductID]) ) RETURN AVERAGEX( temptable,[Count of Products] )