Пікірлер
@ExcelWithChris
@ExcelWithChris 2 күн бұрын
Thanks from South Africa.
@BILingualAnalytics
@BILingualAnalytics Күн бұрын
Happy to help! :)
@BILingualAnalytics
@BILingualAnalytics 4 күн бұрын
Were you aware of these solutions? Do you have an alternative solution to the same problem? Let us know here 👇
@natalialopez1697
@natalialopez1697 9 күн бұрын
hello, great video, could you please share the query you paste when adding the Blank query, thank you!!
@ssomtom
@ssomtom 10 күн бұрын
Szia. Van arra szerinted metódus, hogyha elkezdünk az O365 ökosztisztémákban ilyenekt csinálni, akkor valahogy ezt le is tudjuk kérdezni? Vagyis van egy reportid egy riporthoz és mondja meg, hogy milyen flow-k kapcsolódnak hozzá? Pl. hasznos lehetne munkavállalók mozgásánál, hogy le tudjuk kérdezni, hogy mi történt a múltban.
@BILingualAnalytics
@BILingualAnalytics 9 күн бұрын
Eleg sok mindent ki lehet huzni automate-bol is. A flow -> report mondjuk nem biztos hogy a legegyszerubb. Mi van akkor ha az adat egy dataflow-bol jon ami uj file letrehozasakor frissul (automate); de utana a model mar scheduled refresh-ben mukodik. Ezt megjelolned mint “erintett” report a flow altal? A munkavallalos kerdest nem teljesen latom meg. Irsz egy ket extra mondatot hozza?
@Alan-ps2ul
@Alan-ps2ul 11 күн бұрын
Excellent tutorial which has solved the problem I had with multiple files all with same name but different date stamp. Thank you so much
@BILingualAnalytics
@BILingualAnalytics 9 күн бұрын
Happy to hear that! :)
@shalinderkumar9993
@shalinderkumar9993 13 күн бұрын
Hi Brother, I want to learn Power BI, from where I can learn. So I land my first job as data analyst. Could you please help me ?
@BILingualAnalytics
@BILingualAnalytics 9 күн бұрын
The most important thing is to keep trying. It takes time to master both hard and soft skills. You can find lots of great tutorials online, but first make a decision on what career path (or role) sounds like you
@nkkkkk406
@nkkkkk406 15 күн бұрын
Thanks for the video! What macbook are you using? Is it working perfectly? I want to go for a 24go macbook air but wondering if it would be enough for Power BI
@BILingualAnalytics
@BILingualAnalytics 14 күн бұрын
Mine is an M3Max with 64gb ram. Not sure PBI needs the 64gb model but as I edit videos it makes everything easy :)
@BILingualAnalytics
@BILingualAnalytics 17 күн бұрын
Did you know you can use Field Parameters for such a problem? Let me know!
@antique-bs8bb
@antique-bs8bb 19 күн бұрын
Interesting - I didn't know that . Audio not up to your usual high standard fyi.
@BILingualAnalytics
@BILingualAnalytics 19 күн бұрын
It's good to know - especially if you try to spend lots of time fixing a problem that you won't be able to solve :) Thanks, unfortunately, I only noticed the sound quality after recording 2 videos in the new studio. I'm back to my default mic now, so new ones should be back to the regular quality 🤞
@BILingualAnalytics
@BILingualAnalytics 23 күн бұрын
Did you know that you can do this in Power BI Service? 🧠
@igorarkhipov604
@igorarkhipov604 29 күн бұрын
Great information 🙃
@BILingualAnalytics
@BILingualAnalytics 28 күн бұрын
Thanks!
@sidkings
@sidkings 29 күн бұрын
Unfortunately I have a totally different lay out and can only change colours on data labels and category labels. Very frustrating.
@BILingualAnalytics
@BILingualAnalytics 28 күн бұрын
It might have changed since I published the video :( I have to check
@BILingualAnalytics
@BILingualAnalytics 29 күн бұрын
Were you aware of this limitation? If so, how did you fix it before? I'm keen to hear other options as well!
@tigsik3128
@tigsik3128 Ай бұрын
very nice. Do you have something where once we know the latest month for instance and have this month be selected by default on a slicer so instead of showing all the months we are only showing the filtered latest month. just subscribed! thanks for the videos!
@BILingualAnalytics
@BILingualAnalytics 23 күн бұрын
Should be quite similar but instead of using a single day (ie MAX or MIN) calculate what is the latest month.
@alexspikezak453
@alexspikezak453 Ай бұрын
Link to part 2 please?
@ondaonda-xy5zf
@ondaonda-xy5zf Ай бұрын
Just saved my life thanks legend
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
Happy to hear that! :)
@legendgod
@legendgod Ай бұрын
Could we check the session length of report open?
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
As in for how long someone logged in to the report? To the best of my knowledge no
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
Did you know you can achieve such automation with these simple tricks? Let me know here 👇
@pamelacarbonara9876
@pamelacarbonara9876 Ай бұрын
That's amazing!! I've never thought about it, but I believe it can bring a lot of value for business!
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
I know, right? It is such a simple yet powerful trick!
@rstiekema
@rstiekema Ай бұрын
Where is your video about automated token generation for the powerbi rest api?
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
Still in the works :)
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
And if you want to ungroup those elements just simply delete the text from the Display folder section. Isn't this great?
@cristitrss
@cristitrss Ай бұрын
How can i use power automate to check if my scheduled datasets refresh are failing or not?
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
You either use API connection to pick up the status of the dataset refresh (premium connector) or create a "last updated" measure and apply some logic (IFTTT) and set up an alert.
@AnuragB-hg7xi
@AnuragB-hg7xi Ай бұрын
Hi Roland, I want to append new daily data to existing data pulled. Can you recommend something for that?
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
Hey, yes you can do that. There are a few options to do that. Either use "Add a row into a table" as an Excel connector OR use the "Add rows to dataset" as a Power BI Connector OR create a CSV file and combine with previously exported CSV files :)
@bendavidson1269
@bendavidson1269 Ай бұрын
great vid, do you know id this works with Dax functions on data already in a power dashboard
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
Not sure if I know what you mean by that. Can you please give me a bit more details?
@joshmcgowan4
@joshmcgowan4 Ай бұрын
Nice video thank you. I was hoping this trick would work for a Treemap to show the worst or lowest values in the top left. Unfortunately I could not make it work.
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
I would create a measure based on ranking and use it to drive how you want to sort the Treemap.
@sol_aveiro
@sol_aveiro Ай бұрын
Thank you so much! Very easy-to-follow video!
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
Happy to hear that!
@TBHHyderabad
@TBHHyderabad Ай бұрын
How to Filter reports based on Included in app column
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
I'm not sure if there is a way to do that...
@jdsenuk
@jdsenuk Ай бұрын
Many thanks for showing the 2 methods, definitely solved my problem and I learnt something new.
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
Good to hear the video was useful! :)
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
Did you know it is possible online? Let me know here 👇👇👇
@user-ld8mz8qv1k
@user-ld8mz8qv1k 2 ай бұрын
Hi Great video, I have a table total that I would like to snapshot once a week, is this possible?
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
Absolutely! If it is just a total I’d suggest getting that total out of the table and put it into a card. Then generate the code following the video and it should be super easy :)
@user-ld8mz8qv1k
@user-ld8mz8qv1k Ай бұрын
@@BILingualAnalytics I did it, works perfectly, I have the data coming from SQL, then totaling in a PowerBI visual, then automating via power automate from that visual to a SharePoint list, then back into the PowerBI dashboard!
@BILingualAnalytics
@BILingualAnalytics Ай бұрын
@@user-ld8mz8qv1k Glad to hear it works! :)
@catgentry
@catgentry 2 ай бұрын
Here’s a new one for me. Dataflow refreshes just fine over a table in our database. No additional steps in power query editor. When I connect to the dataflow in my dashboard, the data doesn’t match to the dataflow online or my table in the database. I’ve refreshed (no errors), checked power query editor online for the dataflow and within the dashboard. Doesn’t match. I’m stumped.
@BILingualAnalytics
@BILingualAnalytics 2 ай бұрын
Can you pinpoint to what data is missing? Or what’s causing the difference?
@sudipnarayanchoudhury1112
@sudipnarayanchoudhury1112 2 ай бұрын
Page navigator function box is not taking the measure.. I followed the same process but that fx in destination field is not taking the measure..please help
@BILingualAnalytics
@BILingualAnalytics 2 ай бұрын
It might have changed. Will try to replicate over the weekend.
@user-ze4xc6tu4f
@user-ze4xc6tu4f 2 ай бұрын
U are badass
@BILingualAnalytics
@BILingualAnalytics 2 ай бұрын
Thank you! 🤩
@gauravox
@gauravox 2 ай бұрын
Brother you are awesome currently in 2 days i working on audit dashboard and they have litrelly 50 charts and it consuming litrelly a lot of hours to filtering them but with the help of you i Literally got promotion 😂 thank a lot man appreciate your work and subscribe also keep going 👍🏻
@BILingualAnalytics
@BILingualAnalytics 2 ай бұрын
Glad it worked out for you! Keep up the good work!!!
@olga_p6526
@olga_p6526 2 ай бұрын
i just love you for this solution. literally saved my life. THAAANKS!
@BILingualAnalytics
@BILingualAnalytics 2 ай бұрын
Glad it helped!
@lindarn6--269
@lindarn6--269 2 ай бұрын
@BILingualAnalytics I have scoured the interwebs for a solution in Power BI to track daily data for an agile team, think user stories with status changes daily, in order to build CFD charts, compare planned and completed points over sprints etc, and I can't find anything that seems even close to being able to capture daily data changes into one data set that can easily be stored and queried 😭😭 Could this be a solution for tracking daily data changes to the status of a set of user stories....??
@BILingualAnalytics
@BILingualAnalytics 2 ай бұрын
Potentially could be. However, if the requirement is to track it daily and have a LOTS of data I'd probably look into a proper data warehouse solution. If you only have a handful of datapoints to "track" this will be fine.
@majidtaheri-yq9kq
@majidtaheri-yq9kq 2 ай бұрын
Hi, What should be done if there are several of these data in a single sheet?
@BILingualAnalytics
@BILingualAnalytics 2 ай бұрын
Rinse and repeat :)
@enocharthur4322
@enocharthur4322 2 ай бұрын
This is awesome
@BILingualAnalytics
@BILingualAnalytics 2 ай бұрын
Thank you! :)
@saruncse85
@saruncse85 2 ай бұрын
@Roland thanks for video. Can you point me to how you are creating the measures for legend and showing it on the UI?
@BILingualAnalytics
@BILingualAnalytics 2 ай бұрын
Which part would you like to see more details about?
@saruncse85
@saruncse85 2 ай бұрын
@@BILingualAnalytics on how to display legend based on matrix table values
@BILingualAnalytics
@BILingualAnalytics 2 ай бұрын
@@saruncse85 those are Min | 25th percentile | Median | 75th percentile | Max values in their dedicated card visual. But if you look at Part III, Barnabas shared a much more elegant way of creating the legend
@abderrezzakbendounan9153
@abderrezzakbendounan9153 3 ай бұрын
do you need power bi desktop or power bi pro ?
@BILingualAnalytics
@BILingualAnalytics 3 ай бұрын
You don’t need PRO to replicate this setup (potentially), but I’m nor sure why would you want to replicate without sharing. And for that you will need PRO.
@Wzxxx
@Wzxxx 3 ай бұрын
Never seen such an absolutely crap documentation on any ideas in any software like MS did.. I have no idea how to implement it. It is so counterintuitive. IFs not working, the whole concept od TRUE / FALSE in this area is completely messed up. I see result which are just are completely different from my understanding od Boolean values and DAX after some years of experienced I am 100% stuck in this,
@BILingualAnalytics
@BILingualAnalytics 2 ай бұрын
RLS could be difficult to implement. However, with some practice, I would say most of the things that you would like to apply can be done. Especially with Dynamic RLS
@theophilusanaduaka556
@theophilusanaduaka556 3 ай бұрын
It picks the date from the first file and uses it for every other file in the folder. How do I rectify this
@BILingualAnalytics
@BILingualAnalytics 3 ай бұрын
Have you replicated this method on the sample file or on the combined query?
@theophilusanaduaka556
@theophilusanaduaka556 3 ай бұрын
My bad
@piotro2068
@piotro2068 3 ай бұрын
THank you, very helpful, this was what I was looking for
@BILingualAnalytics
@BILingualAnalytics 3 ай бұрын
Happy to hear that! :)
@mattolenn
@mattolenn 3 ай бұрын
This is such an elegant way of solving a common problem. Your outstanding, clear, concise video enables me to eliminate a lot of inefficient, ugly, or manual workarounds. Much appreciated!
@BILingualAnalytics
@BILingualAnalytics 3 ай бұрын
Thanks for the kind words! Glad you liked it :)
@vladpylypenko4795
@vladpylypenko4795 3 ай бұрын
Many thanks for the video! Still I get “Access to the resource is forbidden”. What type of credentials/access permissions you have used?
@BILingualAnalytics
@BILingualAnalytics 3 ай бұрын
Hey, thanks for the kind words. Do you get that error msg when trying to change the bearer token or right at the first step?
@muhammadrehan6159
@muhammadrehan6159 3 ай бұрын
But you not connect the stored file to the power bi, Than how it will get new incoming values in bi dashboard
@BILingualAnalytics
@BILingualAnalytics 3 ай бұрын
Once you connect to a folder Power BI will be able to pick up all files in the folder.
@KatyaMerezhinska
@KatyaMerezhinska 3 ай бұрын
I watched 10 minutes into the video, and there still was no core information on the alignment. Too much irrelevant talking 😞
@BILingualAnalytics
@BILingualAnalytics 3 ай бұрын
Thanks for your feedback!
@bbiggie97
@bbiggie97 3 ай бұрын
Awesome example thank you!
@BILingualAnalytics
@BILingualAnalytics 3 ай бұрын
Glad it helped you!
@stephenstrickland-bx2jz
@stephenstrickland-bx2jz 3 ай бұрын
I am getting an error "Unable to connect" the "Authorization" header is only when connecting anonymously. I am trying to connect to power bi api from a company computer and account.
@BILingualAnalytics
@BILingualAnalytics 3 ай бұрын
Where do you get that error msg? Thanks