Відео

Great How to get this with embedded and no Power bi ac , use service principal and show report in external web portal , pass Parms to reports

I'm trying to use option 3, but don't have the option to add a directory. I'm using an Azure free account. Any ideas?

Is there any way to make it so the shape that covers the date picker we don't want doesn't disappear when you select from the date picker we do want? I already have the layers set correctly.

TAS EN PUUUUUUUUUUUUUUUUUNGA TE AMO LADOPE

Power Query seems slower than just writing formulas the normal way in Excel. Not sure of the point of it.

Need to mention here that *this ONLY works for Direct Query NOT Import tables mode*

Great tip!!

Wasted two hours of my friday night until you saved my sanity... Thank You!

So I am definitely down the rabbit hole of learning bookmarks and this is fantastic! Can anyone help me with how to keep the selections on the slicer panel when you switch from bookmark to bookmark?

Is it better to create a table in DAX from the date columns in other tables and then add columns like month number, month name, fiscal period, fiscal quarter, etc., or is it better to create these columns in SQL and then import a comprehensive date table with all these attributes?

Thank you so much this is very helpful

What would be the server and database name if the i am importing the file saved on the one drive as excel workbook?

Very helpful

Thanks man, one hour looking for this

It works great for your specific use case. But if I have many lines in my line chart, and want to conditionnally format each one of them ? It doesn't work anymore, as the formatting option disappear even from the bar plot visual !

How to sort the values in the parameter alphabetically?

We are screwed with this Copilot 😅

Nyce graphic on that T!

Nyce! Let's do some sync slices!:)

Really useful material. Does it require premium workspace?

I'm wondering, if you want those slicer panel on multiple sheets, you need to make a bookmark for each sheet? (just started with power BI)

This issue with this approach is that I have all the data already queried. I need a solution where i can use slicers data to query APIs dynamically and populate in a table. like the moment i change the slicer data, the report should go fetch the data from the api and populate a grid below. Kindly share if you have any such solution that you may have presented.

Does the copilot work for reportS which is embedded in application with app owns data model.Details: Reports are present in fabric capacity with F64 Size

Hi Patrick I have this measure that returns text such as 50/12% BAC+ = IF([# BAC+]>0, FORMAT([# BAC+],"0") & "/" & FORMAT([% BAC+],"0%"),"") I want to conditionally format this measure using the following measure Met Bac+ target = IF( [bac+ target]<1, "", IF( [% BAC+] < [bac+ target] * [lower bound], "#FF4136", -- Target Not Met IF( [% BAC+] < [bac+ target]*[middle bound], "#FF8F00", -- Close to Target "#2E7D32" -- Target Met ) ) ) however, Power BI does format the text values, what am I doing wrong in this case? Thank you for all your education

Thanks!

I have excel 2016 and for the life of me can't find where to copy the path from 😢

Huge thanks for this. I have spend many a report trying to resolve this and it is such a simple issue on the face of it. Yet, it is so obvious people will probably not even think of it. I am one of those people. Has now helped me out massively so have Subscribed to your channel which is the least I can do to show my appreciation!

This is legitimately one of the best PQ tips on the internet.

Microsoft is so greedy

3 years old and STILL a life saver. Brilliant. Been struggling with this for hours until I found this video. I'm using it in a custom data label, but it all still applies. Thanks guys!

how is the paginated report using the email address to do the filtering for the paginated report?

Not very good solution. 1. I prefer using field parameter then hidden pages. 2. If I have more RLS (e.g. by Regions) and more combination of OLS (e.g. Finance, Sales, etc ...) then Iwould need ALL (!) combinations to have 1 single role for every possible roles (e.g. for every Region, for Global + for Finance, Sales, Finance + Sales etc ...). I still don`t understand why a combination of more RLS + OLS is not possible.

Thanks for this video Question. This work just for 1 PBI report. What can I do having several PBI reports? All PBI reports are connected to the same data source/Server location and I need to change it to a new Server location. Is there a way to change all data source across all PBI reports rather than open and do it one by one? Thanks

Thanks for this video Question. This work just for 1 PBI report. What can I do having several PBI reports? All PBI reports are connected to the same data source/Server location and I need to change it to a new Server location. Is there a way to change all data source across all PBI reports rather than open and do it one by one? Thanks

I'm having similar issue with x axis. I created index and sortby but cannot use them. To be more specific, I created week of the years in the format of mm/dd. But that puts 4/13 in front of 4/7. I need 4/7 to be in front of 4/13. Little things like this make me miss Tableau.

THANK YOU!

I would consider it a security vulnerability to enable "Allow Azure services and resources to access this server" because that applies to all Azure customers.

How can I add text box repetitively in report body on each every page. I tried properties like report eith....

this helped, thank you so much..

This was immensely helpful!!! Thank you <3

Good to know but doesn't help my unique situation of trying to color code values of average days to fill based on SLA target values.

So to recap this video, Dataflow is like when you have master's DB/ OLAP in master company and you're in PowerBI service team area, you want to pick some of its table and do major ETL to further report or re-use for another team But Datamart is like when your team does not fulfill permission to access master DB/ OLAP, ... so you can use Datamart and ask IT team to pull some of the partitions you need to do your report, whatever, ... Is this understanding method proper?

I have the PL 300 Certification and I wanted to know if getting DP 600 helps me get better job opportunities? or If you can guide what other certifications to get. I currently am certified in both Tableau and PowerBI.

Comment: Today I had an extensive Power Bi session (trying to transition from Tableau since where I live Power Bi is more demanded than Tableau) and the Parameter bit had me worried because I couldn’t wrap my head around it, so I came across this video and I didn’t realize how simple this was to understand. Thank you!!!!

You are awesome....

As a consultant I work for several clients using my computer to start PBI with the runas command (runas /noprofile /netonly /user:<domain>\<user> "C:\Program Files\Microsoft Power BI Desktop\bin\PBIDesktop.exe"). Finding the path to the executable is easy when you install the app the old fashion way, but it is more difficult to find the executable when you install with MS Store. Do you have a preferred way to find the exec when you use MS store?

Not working on a multi card visual, as the measure breakdown is frozen, What to do in that scenario

Great guide, thanks. Just one question: I am also using shape map visual as a filter in my slicer pane. While other visuals work great, the selection I make throught the shape map visual always resets after showing/hiding slicer pane. Would you have an advice how to solve this issue?