![Curbal](/img/default-banner.jpg)
- 1 050
- 18 707 342
Curbal
Sweden
Приєднався 10 вер 2014
Curb your Power BI skils!
I update the channel once a week with:
1. Useful dashboards with popular online data sources like Google Analytics, Twitter, Northwind database, etc..
2. The latest Power BI updates
3. Power BI tips& tricks
5. DAX Fridays, where we go through new DAX measures features every Friday. Perfect to learn DAX for beginners and experts.
Join me, I publish new videos every week!
/Ruth
I update the channel once a week with:
1. Useful dashboards with popular online data sources like Google Analytics, Twitter, Northwind database, etc..
2. The latest Power BI updates
3. Power BI tips& tricks
5. DAX Fridays, where we go through new DAX measures features every Friday. Perfect to learn DAX for beginners and experts.
Join me, I publish new videos every week!
/Ruth
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
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!
Ja ja ! Me había olvidado que eras española !! Pensé que era un fake !
😂😂
but what if I have a large amount of data?
if i deploy my dashboard into my website, how is an unknown person going to access the exported file
love this. Its awesome
If only power query would perform calculations despite errors. I don't understand why having one error messes up the whole process.
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.
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!!!
Hi This will not work in the line charts then what is the approch i can change
@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
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?
If I do this, it would not make links clickable right? It only keeps simple text with proper visual order?
You can make the text clickable if you transform the field to a webURL
@@CurbalEN But I want the transformation to be automatic once a week, is it still possible?
Thanks
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.
Ahhh I'm so excited to try this!!
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!!
Just the thing I need!
how to get the code in notepad?
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!
🤷♀️🤷♀️🤷♀️
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?
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!!! 😎😎😱😱😱😱😱😱💪🏼💪🏼
🥳🥳
That's amazing. Your are a life saver.
Soy profesional de Power BI y estudiante de espanol. Por eso me gusto mucho el video!
Doble ganancia!
Thank you
Here is how you rename columns in Power Automate: ua-cam.com/video/lWu4n-ODe4U/v-deo.html&ab_channel=Curbal
Great Thank you. Your content is helpful.And thanks for replying.😇
@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]?
Here is how you rename columns in Power Automate: ua-cam.com/video/lWu4n-ODe4U/v-deo.html&ab_channel=Curbal
What type of job do you do that you get to use these skills? Thank you
I am a Power BI consultant
Tried this again, filters don't appear to work with this method.
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 😅
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
I use this function because all line have to call api endpoint filtering on cell's values. And then I expand the response
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!
This is great! Thank you for sharing!
Can anybody help why my formula is not correct? Day 9 =AVERAGEX ( FILTER(Orders, Orders[ShipName] = "Romero y tomillo"), [Total Sales] )
thank you very much, you saved my day. Amazing work!
on some value its showing 2 M instead of 200 M..
No such Extension Exists now .
There are others , just google it :)
Muchas gracias. Encantado de escucharte
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
Yeah, hacks are like that, they kind of work but with limitations. I hope MS implements this !
Where do I get that course?
Here: curbal.com/course/power-bi-mini-master-class-1-using-a-rest-api-as-a-data-source
Cool! But what if I need to keep a certain filter. I do not want to remove all.?
Lovely... This would be very informative. 👍
The course is available in the website curbal.com
Wow.. that would be a great learning for us and from a master like you ..!!🙇🏽♀️ Looking forward for it..
It is live at curbal.com :) Check the description box in the video
Short and concise
That is how we like it around here :)
@@CurbalEN so much more to learn from you 👍🏻
@ali.jawwad ❤️
Hi, Is this matrix design a background image? :)
It is ! m.ua-cam.com/video/97M-D5WXaqI/v-deo.html
@@CurbalEN Thanks!!! (from Brasil)
Obrigada :)
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.
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.
Thanks for sharing!
You are incredible!
Increible! sorprendió mucho
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
Web queries require a personal gateway :(
@@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 ?
@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/
Hello Curbal, i can´t see he function in the Marks blog. Could you upload it to some repository?
Try this one instead, is more robust: m.ua-cam.com/video/47xHUsbBDnQ/v-deo.html
Is shopify as a datasource will be implemented?
You scored 6 on 5🎉, very nice explanation. Keep in driving us in the smartest way of consolidations...
🥳🥳
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?