Пікірлер
@loub7398
@loub7398 5 сағат бұрын
What type of job do you do that you get to use these skills? Thank you
@CurbalEN
@CurbalEN 8 минут бұрын
I am a Power BI consultant
@ryanclark3527
@ryanclark3527 6 сағат бұрын
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 13 сағат бұрын
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 13 сағат бұрын
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 16 сағат бұрын
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 4 күн бұрын
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? :)
@CurbalEN
@CurbalEN 5 күн бұрын
It is ! m.kzfaq.info/get/bejne/b519YKdmvL7FoX0.html
@EncontroLegionarioOficial
@EncontroLegionarioOficial 5 күн бұрын
@@CurbalEN Thanks!!! (from Brasil)
@CurbalEN
@CurbalEN 4 күн бұрын
Obrigada :)
@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) KZfaq 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.kzfaq.info/get/bejne/ap2oe7ikx6ionoU.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...
@CurbalEN
@CurbalEN 6 күн бұрын
🥳🥳
@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.
@CurbalEN
@CurbalEN 7 күн бұрын
😃
@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¡¡
@CurbalEN
@CurbalEN 7 күн бұрын
😄
@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 7 күн бұрын
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 7 күн бұрын
Oido cocina! 😉
@danher4607
@danher4607 8 күн бұрын
Por favor, haz videos en español, tieen varios suscriptores de altinoamerica.
@CurbalEN
@CurbalEN 7 күн бұрын
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] )