What type of job do you do that you get to use these skills? Thank you
@CurbalEN8 минут бұрын
I am a Power BI consultant
@ryanclark35276 сағат бұрын
Tried this again, filters don't appear to work with this method.
@Srivatsa22413 сағат бұрын
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 😅
@bboykaze953813 сағат бұрын
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
@bboykaze953813 сағат бұрын
I use this function because all line have to call api endpoint filtering on cell's values. And then I expand the response
@CurbalEN12 сағат бұрын
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!
@sn3ider16 сағат бұрын
This is great! Thank you for sharing!
@neelamnainiwal67112 күн бұрын
Can anybody help why my formula is not correct? Day 9 =AVERAGEX ( FILTER(Orders, Orders[ShipName] = "Romero y tomillo"), [Total Sales] )
@shubhamjain24232 күн бұрын
thank you very much, you saved my day. Amazing work!
@DimDims132 күн бұрын
on some value its showing 2 M instead of 200 M..
@ankitmehrotra61043 күн бұрын
No such Extension Exists now .
@CurbalEN3 күн бұрын
There are others , just google it :)
@marcosgarrido34523 күн бұрын
Muchas gracias. Encantado de escucharte
@nomad92963 күн бұрын
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
@CurbalEN3 күн бұрын
Yeah, hacks are like that, they kind of work but with limitations. I hope MS implements this !
Cool! But what if I need to keep a certain filter. I do not want to remove all.?
@abhijeetghosh274 күн бұрын
Lovely... This would be very informative. 👍
@CurbalEN4 күн бұрын
The course is available in the website curbal.com
@Im_Thanos4 күн бұрын
Wow.. that would be a great learning for us and from a master like you ..!!🙇🏽♀️ Looking forward for it..
@CurbalEN4 күн бұрын
It is live at curbal.com :) Check the description box in the video
@ali.jawwad4 күн бұрын
Short and concise
@CurbalEN4 күн бұрын
That is how we like it around here :)
@ali.jawwad4 күн бұрын
@@CurbalEN so much more to learn from you 👍🏻
@CurbalEN4 күн бұрын
@ali.jawwad ❤️
@EncontroLegionarioOficial5 күн бұрын
Hi, Is this matrix design a background image? :)
@CurbalEN5 күн бұрын
It is ! m.kzfaq.info/get/bejne/b519YKdmvL7FoX0.html
@EncontroLegionarioOficial5 күн бұрын
@@CurbalEN Thanks!!! (from Brasil)
@CurbalEN4 күн бұрын
Obrigada :)
@KsrikYT5 күн бұрын
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.
@adrianjliu6 күн бұрын
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.
@CurbalEN6 күн бұрын
Thanks for sharing!
@MeIrritaIsso6 күн бұрын
You are incredible!
@user-uc2cq8vp9n6 күн бұрын
Increible! sorprendió mucho
@arossi9016 күн бұрын
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
@CurbalEN6 күн бұрын
Web queries require a personal gateway :(
@arossi9015 күн бұрын
@@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 ?
@CurbalEN5 күн бұрын
@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/
@2013Nicomusic6 күн бұрын
Hello Curbal, i can´t see he function in the Marks blog. Could you upload it to some repository?
@CurbalEN6 күн бұрын
Try this one instead, is more robust: m.kzfaq.info/get/bejne/ap2oe7ikx6ionoU.html
@mrNikkky6 күн бұрын
Is shopify as a datasource will be implemented?
@MrSssscccc6 күн бұрын
You scored 6 on 5🎉, very nice explanation. Keep in driving us in the smartest way of consolidations...
@CurbalEN6 күн бұрын
🥳🥳
@johnlhaase6 күн бұрын
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?
@matheussiedler6 күн бұрын
What a great video! You really helped me with a project I'm developing. One more subscriber to the channel!
@christianhartgrove6 күн бұрын
THANK YOU!
@claroseduardo6 күн бұрын
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
@CurbalEN6 күн бұрын
Soy española :)
@claroseduardo5 күн бұрын
@@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!
@CurbalEN5 күн бұрын
Copiar el query en power bi desktop :) Saludos de una asturiana !
@emiliachauturewicz81417 күн бұрын
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) ) )
@alexrosen87627 күн бұрын
Yes! Looking forward to it
@juliom62607 күн бұрын
Thanks
@Massiminesta95687 күн бұрын
Amazing content! Looking forward!
@rodrigochavez77 күн бұрын
How many hours will have the course? This is the first course related to APIs that I have seen, really excited for that!
@juliom62607 күн бұрын
1:08
@CurbalEN7 күн бұрын
One hour. Perfect to get started!
@gulhermepereira2497 күн бұрын
looking forward for that course! Thank you
@tracy29197 күн бұрын
❤
@ashishchanchalverma57227 күн бұрын
I cannot download this pbix file. Please help me to download
@atharshabuddin38127 күн бұрын
Wow! That sounds great. Really excited for the upcoming course. Thank you.
@CurbalEN7 күн бұрын
😃
@BarbaraCarolineFerreiradaSilva7 күн бұрын
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?
@CurbalEN7 күн бұрын
Post the details on the powerautomate community. They should be able to help you!
@baskis697 күн бұрын
Que sea el primero de muchos¡¡
@CurbalEN7 күн бұрын
😄
@sarajvo20107 күн бұрын
Best content creator! Thx you
@rahupradhan18897 күн бұрын
Could you please make a video on " How to load data from SAP systems and SQL Data base " Please 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏 🙏❤❤❤
@CurbalEN7 күн бұрын
I dont have access to any public SAP I could demo
@rahupradhan18897 күн бұрын
@@CurbalEN any idea from where I can find those content
@CurbalEN7 күн бұрын
@rahupradhan1889 not sure , do a google search, something should come up
@kishanbhise47337 күн бұрын
What if i have 1000 different schools ?
@user-fz1ns1nd9t7 күн бұрын
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
@lukemanthuruthil22758 күн бұрын
Can you do this without access to data source?
@CurbalEN7 күн бұрын
I dont think so
@geineralbertomejiagarzon40348 күн бұрын
Que sea el primero de muchos vídeos más en español. Gracias por ello Ruth. 👍🏽
@CurbalEN7 күн бұрын
Oido cocina! 😉
@danher46078 күн бұрын
Por favor, haz videos en español, tieen varios suscriptores de altinoamerica.
@CurbalEN7 күн бұрын
Que os gustaria ver?
@edwardwernich92598 күн бұрын
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-gi3wo5vz1m8 күн бұрын
how did you get that background?
@CurbalEN8 күн бұрын
I made it in figma
@TheAtulsachan12349 күн бұрын
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] )