Were you aware of these solutions? Do you have an alternative solution to the same problem? Let us know here 👇
@natalialopez16979 күн бұрын
hello, great video, could you please share the query you paste when adding the Blank query, thank you!!
@ssomtom10 күн бұрын
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.
@BILingualAnalytics9 күн бұрын
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-ps2ul11 күн бұрын
Excellent tutorial which has solved the problem I had with multiple files all with same name but different date stamp. Thank you so much
@BILingualAnalytics9 күн бұрын
Happy to hear that! :)
@shalinderkumar999313 күн бұрын
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 ?
@BILingualAnalytics9 күн бұрын
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
@nkkkkk40615 күн бұрын
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
@BILingualAnalytics14 күн бұрын
Mine is an M3Max with 64gb ram. Not sure PBI needs the 64gb model but as I edit videos it makes everything easy :)
@BILingualAnalytics17 күн бұрын
Did you know you can use Field Parameters for such a problem? Let me know!
@antique-bs8bb19 күн бұрын
Interesting - I didn't know that . Audio not up to your usual high standard fyi.
@BILingualAnalytics19 күн бұрын
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 🤞
@BILingualAnalytics23 күн бұрын
Did you know that you can do this in Power BI Service? 🧠
@igorarkhipov60429 күн бұрын
Great information 🙃
@BILingualAnalytics28 күн бұрын
Thanks!
@sidkings29 күн бұрын
Unfortunately I have a totally different lay out and can only change colours on data labels and category labels. Very frustrating.
@BILingualAnalytics28 күн бұрын
It might have changed since I published the video :( I have to check
@BILingualAnalytics29 күн бұрын
Were you aware of this limitation? If so, how did you fix it before? I'm keen to hear other options as well!
@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!
@BILingualAnalytics23 күн бұрын
Should be quite similar but instead of using a single day (ie MAX or MIN) calculate what is the latest month.
@alexspikezak453Ай бұрын
Link to part 2 please?
@ondaonda-xy5zfАй бұрын
Just saved my life thanks legend
@BILingualAnalyticsАй бұрын
Happy to hear that! :)
@legendgodАй бұрын
Could we check the session length of report open?
@BILingualAnalyticsАй бұрын
As in for how long someone logged in to the report? To the best of my knowledge no
@BILingualAnalyticsАй бұрын
Did you know you can achieve such automation with these simple tricks? Let me know here 👇
@pamelacarbonara9876Ай бұрын
That's amazing!! I've never thought about it, but I believe it can bring a lot of value for business!
@BILingualAnalyticsАй бұрын
I know, right? It is such a simple yet powerful trick!
@rstiekemaАй бұрын
Where is your video about automated token generation for the powerbi rest api?
@BILingualAnalyticsАй бұрын
Still in the works :)
@BILingualAnalyticsАй бұрын
And if you want to ungroup those elements just simply delete the text from the Display folder section. Isn't this great?
@cristitrssАй бұрын
How can i use power automate to check if my scheduled datasets refresh are failing or not?
@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Ай бұрын
Hi Roland, I want to append new daily data to existing data pulled. Can you recommend something for that?
@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Ай бұрын
great vid, do you know id this works with Dax functions on data already in a power dashboard
@BILingualAnalyticsАй бұрын
Not sure if I know what you mean by that. Can you please give me a bit more details?
@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Ай бұрын
I would create a measure based on ranking and use it to drive how you want to sort the Treemap.
@sol_aveiroАй бұрын
Thank you so much! Very easy-to-follow video!
@BILingualAnalyticsАй бұрын
Happy to hear that!
@TBHHyderabadАй бұрын
How to Filter reports based on Included in app column
@BILingualAnalyticsАй бұрын
I'm not sure if there is a way to do that...
@jdsenukАй бұрын
Many thanks for showing the 2 methods, definitely solved my problem and I learnt something new.
@BILingualAnalyticsАй бұрын
Good to hear the video was useful! :)
@BILingualAnalyticsАй бұрын
Did you know it is possible online? Let me know here 👇👇👇
@user-ld8mz8qv1k2 ай бұрын
Hi Great video, I have a table total that I would like to snapshot once a week, is this possible?
@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Ай бұрын
@@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Ай бұрын
@@user-ld8mz8qv1k Glad to hear it works! :)
@catgentry2 ай бұрын
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.
@BILingualAnalytics2 ай бұрын
Can you pinpoint to what data is missing? Or what’s causing the difference?
@sudipnarayanchoudhury11122 ай бұрын
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
@BILingualAnalytics2 ай бұрын
It might have changed. Will try to replicate over the weekend.
@user-ze4xc6tu4f2 ай бұрын
U are badass
@BILingualAnalytics2 ай бұрын
Thank you! 🤩
@gauravox2 ай бұрын
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 👍🏻
@BILingualAnalytics2 ай бұрын
Glad it worked out for you! Keep up the good work!!!
@olga_p65262 ай бұрын
i just love you for this solution. literally saved my life. THAAANKS!
@BILingualAnalytics2 ай бұрын
Glad it helped!
@lindarn6--2692 ай бұрын
@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....??
@BILingualAnalytics2 ай бұрын
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-yq9kq2 ай бұрын
Hi, What should be done if there are several of these data in a single sheet?
@BILingualAnalytics2 ай бұрын
Rinse and repeat :)
@enocharthur43222 ай бұрын
This is awesome
@BILingualAnalytics2 ай бұрын
Thank you! :)
@saruncse852 ай бұрын
@Roland thanks for video. Can you point me to how you are creating the measures for legend and showing it on the UI?
@BILingualAnalytics2 ай бұрын
Which part would you like to see more details about?
@saruncse852 ай бұрын
@@BILingualAnalytics on how to display legend based on matrix table values
@BILingualAnalytics2 ай бұрын
@@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
@abderrezzakbendounan91533 ай бұрын
do you need power bi desktop or power bi pro ?
@BILingualAnalytics3 ай бұрын
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.
@Wzxxx3 ай бұрын
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,
@BILingualAnalytics2 ай бұрын
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
@theophilusanaduaka5563 ай бұрын
It picks the date from the first file and uses it for every other file in the folder. How do I rectify this
@BILingualAnalytics3 ай бұрын
Have you replicated this method on the sample file or on the combined query?
@theophilusanaduaka5563 ай бұрын
My bad
@piotro20683 ай бұрын
THank you, very helpful, this was what I was looking for
@BILingualAnalytics3 ай бұрын
Happy to hear that! :)
@mattolenn3 ай бұрын
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!
@BILingualAnalytics3 ай бұрын
Thanks for the kind words! Glad you liked it :)
@vladpylypenko47953 ай бұрын
Many thanks for the video! Still I get “Access to the resource is forbidden”. What type of credentials/access permissions you have used?
@BILingualAnalytics3 ай бұрын
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?
@muhammadrehan61593 ай бұрын
But you not connect the stored file to the power bi, Than how it will get new incoming values in bi dashboard
@BILingualAnalytics3 ай бұрын
Once you connect to a folder Power BI will be able to pick up all files in the folder.
@KatyaMerezhinska3 ай бұрын
I watched 10 minutes into the video, and there still was no core information on the alignment. Too much irrelevant talking 😞
@BILingualAnalytics3 ай бұрын
Thanks for your feedback!
@bbiggie973 ай бұрын
Awesome example thank you!
@BILingualAnalytics3 ай бұрын
Glad it helped you!
@stephenstrickland-bx2jz3 ай бұрын
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.