![Curbal](/img/default-banner.jpg)
- Видео 1 050
- Просмотров 18 662 361
Curbal
Швеция
Добавлен 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:
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....
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!
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.ruclips.net/video/97M-D5WXaqI/видео.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) 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.
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.ruclips.net/video/47xHUsbBDnQ/видео.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?
What a great video! You really helped me with a project I'm developing. One more subscriber to the channel!
THANK YOU!
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
Soy española :)
@@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!
Copiar el query en power bi desktop :) Saludos de una asturiana !
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) ) )
Yes! Looking forward to it
Thanks
Amazing content! Looking forward!
How many hours will have the course? This is the first course related to APIs that I have seen, really excited for that!
1:08
One hour. Perfect to get started!
looking forward for that course! Thank you
❤
I cannot download this pbix file. Please help me to download
Wow! That sounds great. Really excited for the upcoming course. Thank you.
😃
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?
Post the details on the powerautomate community. They should be able to help you!
Que sea el primero de muchos¡¡
😄
Best content creator! Thx you
Could you please make a video on " How to load data from SAP systems and SQL Data base " Please 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏❤❤❤
I dont have access to any public SAP I could demo
@@CurbalEN any idea from where I can find those content
@rahupradhan1889 not sure , do a google search, something should come up
What if i have 1000 different schools ?
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
Can you do this without access to data source?
I dont think so
Que sea el primero de muchos vídeos más en español. Gracias por ello Ruth. 👍🏽
Oido cocina! 😉
Por favor, haz videos en español, tieen varios suscriptores de altinoamerica.
Que os gustaria ver?
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!!
how did you get that background?
I made it in figma
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] )