![Power BI Tips](/img/default-banner.jpg)
- 578
- 2 405 838
Power BI Tips
United States
Приєднався 19 чер 2017
This is the official PowerBI.Tips UA-cam channel. Videos and content provided by PowerBI.Tips will be shared here.
Відео
Tips + Theme Generator Tutorial - Gallery - Copy & Edit
Переглядів 101 тис.6 місяців тому
Tips Theme Generator Tutorial - Gallery - Copy & Edit
Fabric Learn about the Lakehouse - Season 7 Ep. 1
Переглядів 20 тис.6 місяців тому
Fabric Learn about the Lakehouse - Season 7 Ep. 1
Fabric and the Lakehouse - Season 7 Ep.3
Переглядів 25 тис.6 місяців тому
Fabric and the Lakehouse - Season 7 Ep.3
Fabric Parquet and Delta Tables - Season 7 Ep.2
Переглядів 22 тис.6 місяців тому
Fabric Parquet and Delta Tables - Season 7 Ep.2
Tips + Theme Generator Tutorial - Gallery Project Download Tutorial
Переглядів 7297 місяців тому
Tips Theme Generator Tutorial - Gallery Project Download Tutorial
Creating Layouts and Themes - Season 6 Ep.3
Переглядів 46 тис.11 місяців тому
Creating Layouts and Themes - Season 6 Ep.3
Error Importing Theme File - Quick Tip
Переглядів 2,9 тис.Рік тому
Error Importing Theme File - Quick Tip
Strong Spoke, No Hub - Ep.127 - Power BI Tips from the Real World
Переглядів 5542 роки тому
Strong Spoke, No Hub - Ep.127 - Power BI Tips from the Real World
The Lost Episode - Ep.84 - Power BI Tips from the Real World
Переглядів 4622 роки тому
The Lost Episode - Ep.84 - Power BI Tips from the Real World
Goals - Creating Your First Scorecard and Goal - Season 4 Ep. 3
Переглядів 1,1 тис.2 роки тому
Goals - Creating Your First Scorecard and Goal - Season 4 Ep. 3
Goals - Status Based Rules - Season 4 Ep. 6
Переглядів 3162 роки тому
Goals - Status Based Rules - Season 4 Ep. 6
Goals - Connecting to Cards, Bar and Line Charts - Season 4 Ep. 5
Переглядів 8002 роки тому
Goals - Connecting to Cards, Bar and Line Charts - Season 4 Ep. 5
Goals - Connecting Data From a Report - Season 4 Ep. 4
Переглядів 3812 роки тому
Goals - Connecting Data From a Report - Season 4 Ep. 4
Goals - Component Overview - Season 4 Ep. 2
Переглядів 3292 роки тому
Goals - Component Overview - Season 4 Ep. 2
Deneb - Introduction - Season 3 Ep. 1
Переглядів 4,9 тис.2 роки тому
Deneb - Introduction - Season 3 Ep. 1
Power BI Version Control - Installation and Configuration
Переглядів 13 тис.2 роки тому
Power BI Version Control - Installation and Configuration
Power BI Version Control - How to Use The App
Переглядів 9 тис.2 роки тому
Power BI Version Control - How to Use The App
App Build - Demo of Order Fulfillment App - Milwaukee Power Platform User Group
Переглядів 6042 роки тому
App Build - Demo of Order Fulfillment App - Milwaukee Power Platform User Group
A Human Centered Process | Getting the most out of the Power Platform - Milwaukee Power Platform
Переглядів 2152 роки тому
A Human Centered Process | Getting the most out of the Power Platform - Milwaukee Power Platform
Do you need to join a User Group to be a PBI Pro - Episode 032 - Explicit Measures - Podcast
Переглядів 1793 роки тому
Do you need to join a User Group to be a PBI Pro - Episode 032 - Explicit Measures - Podcast
Table or No Table - Episode 031 - Explicit Measures - Podcast
Переглядів 3503 роки тому
Table or No Table - Episode 031 - Explicit Measures - Podcast
Introduction to Power BI Embedded - Data Minds Presentation
Переглядів 19 тис.3 роки тому
Introduction to Power BI Embedded - Data Minds Presentation
MVPs React - Feb 2021 - Desktop Update - Live Edit
Переглядів 1423 роки тому
MVPs React - Feb 2021 - Desktop Update - Live Edit
PowerBI.tips - Tutorial - Modify Default Dataset
Переглядів 3,2 тис.3 роки тому
PowerBI.tips - Tutorial - Modify Default Dataset
PowerBI.tips - Hot Swap Connections Webinar
Переглядів 7 тис.3 роки тому
PowerBI.tips - Hot Swap Connections Webinar
PowerBI.tips - PUG - External Tools & Business Ops
Переглядів 1,8 тис.4 роки тому
PowerBI.tips - PUG - External Tools & Business Ops
PowerBI.tips - Tutorial - Monkey Tool Introduction - Part 2
Переглядів 9384 роки тому
PowerBI.tips - Tutorial - Monkey Tool Introduction - Part 2
For Paginated Reports we need to share, we store them in a dedicated PPU workspace and use Power Automate to send out reports to external users, who don't have Power BI Licenses. So, it requires one PPU license which is $20/month.
The best way I've found to help business users understand the difference between a dashboard and report is with an analogy: "Imagine you're driving your car, and you need to check how fast you're going, how much gas you have left, whether your tires are all properly inflated, and whether the temperature and pressure of both your coolant and oil are within the normal operating ranges, and you have to do all of that in less than 5 seconds, because you can't take your eyes off the road for any longer than that. You have two tools you can use for this task: The first option is the car's built-in dashboard right in front of you. It's non-interactive, so you can't slice and dice, drill-down, etc. But all of your car's Key Performance Indicators are right there, exactly where you need them. The second option is a laptop on the seat next to you, which is plugged into the OBD-II port under your steering wheel, and it can give you the exact readings of every sensor in the entire vehicle over time. It has endless tables full of sensor IDs and diagnostic codes, each of which has its own lookup table, and there are interactive filters that you can use to display only the data collected during certain ranges of time, or from specific sensors. Now, which of these two tools will you use when you need to check your car's Key Performance Indicators while driving down the road?"
Mike & Tommy should starting dropping the “bi” and just start saying Power. “Hey Seth can you open Power” 😂
Can you pull multiple metric collection to create a new semantic model?
Quick Question - I have a PowerBI dev space and prod space with a deployment pipeline. However, I have a few bookmarks that are in dev space, that don't show up in the prod side even after deployment. There's no difference showing up when I compare the semantic model and the report between the dev and prod workspaces. Any insight into this quirk? Do bookmarks not get migrated/deployed through the deployment pipeline from the dev to the prod workspace?
Why don't you guys just use the Microsoft Store version of Power BI Desktop? If there is a bug, it will be fixed and updated faster than the manual version.
I love that I found this video, looking for the answer of why I was getting the same issue!
Great content both, I was struggling with where to find user friendly resources, and those you have described (and run through in this session) are ideal.
this was very educational and informative. thank you!
I agree on the power of themes for this Atomic model. I've created a custom JSON theme template that format's all of my most standard visuals in a standard way. It's two clicks to upload this to each PBIX and after it's updated every visual I create are already standardized. I think that the on-object editing helps with the visual pattern piece as you should be able to swap fields in your current model with the broken field. I am pretty sure this is a feature but you have to be in on-object editing. It works pretty slick that way
Amazing job guys!
I like Tommy's point about the "forgotten middle child" and I think that's an insightful add. The 30 seconds part about helping people to direct where they should focus their attention -is- in a lot of ways the hardest part of the design and UX build process.
FYI It looks like Microsoft has removed delta_column_mapping_mode from to_lakehouse_table. Had to use write instead and the table is showing up in my sql endpoint and semantic model.
I don't think so based on this documentation it is an optional, learn.microsoft.com/python/api/semantic-link-sempy/sempy.fabric.fabricdataframe?view=semantic-link-python&WT.mc_id=DP-MVP-5002621#sempy-fabric-fabricdataframe-to-lakehouse-table the default setting is set to "name" which is using column mapping, if you don't want column mapping you must set this to "none" by setting it to none then you would be able to see the table inside the SQL Analytics endpoint.
@@PowerBITips That’s what i thought too. Do give it another try to validate this and let me know if it works for you?
@@PowerBITips I can't seem to find the delta_column_mapping_mode parameter either. ?df.to_lakehouse_table doesn't show that anymore.
@kel78v2 what do you mean by had to use write? I can't seem to find a method called write or any other method to write a fabric df to a delta table.
This is great. Thank you so much. I love the easy access to the PBI metadata for admins.
/ⁿ😮9(
😊😊म
@@viratthakur-m9q4:28 hu 😊 4:53 4:40
facing some issues in PayPal payments on power.tip to buy annual subscription... Could nt find any customer support email or so, is anyone around who can help me
😅 ❤❤
Hi is this still the best approach?
I think the 10000 hours reference from Malcolm Gladwell's "Outliers" refers to mastery and not to becoming an expert; and it refers to art, or at least this was the basis of the "The role of deliberate practice in the acquisition of expert performance" study. In IT the definition of an expert is probably more relaxed than in the arts. There's also a quote from Bruce Lee, which depicts what it takes to become a master in martial arts: "I fear not the man who has practiced 10,000 kicks once, but I fear the man who has practiced one kick 10,000 times."
I am Dr Worm was very popular on Triple J radio in Australia. It got to #13 in the hottest 100 of 1998.
I've heard folks discuss the Malcom Gladwell number and say that it's a misrepresentation. That 10,000 is to be the best of the best. Not sure what those same people say is needed to qualify as an expert. However, I get your 👉
My trial started at 60 days. It got down to 6 days yesterday and I was bracing myself for having to spin up an F2. But when I logged in today, my trial is now at 29 days.
Been getting a 403 error whenever attempting to access any Power BI API endpoint 🤧... Gone through loads of tutorials and stack overflow threads and have checked every box there. Do I need to use a pro version in order to access the API? I have a trial version.
What api endpoint are you trying to hit? If you are accessing the endpoint as a user you will need different permissions than a service principal.
There are also admin tenant settings that need to be turned on to use the APIs with an app registration ( service principal )
@@PowerBITips Hey thanks for replying!!! Problem was fixed: I was using an old endpoint to generate a token... If anyone reading is having trouble one thing may help: double and triple check you are using every correct endpoint!!!
Hello Mike, This video is completely awesome, Can you please explain how to embed using pro license. As you did with service principle?
a Pro license only allows for a limited number of embeds, while you can embed reports from a pro workspace, this is not a sustainable solution. A premium capacity is required to embed reports into applications, either a P, A, EM or F sku is required to have embedding work. There are also license considerations, a P sku can be used for internal and external embedding, an A sku is for ISV of external only, an EM sku is for internal embedding and an F sku is for both internal and external embedding. my recommendation to customers is only use the F sku as it has the most flexibility in cost and embeds for both internal and external users.
Shape Map visual is still in preview...
Useful. Thank you!
Thank u! At right time I received you video
CAN i add measures when im live connecting to a dataset using this tool ?
Manoda ke janina yadi pustak na deo hoto. O ki amar maa na premi. She is a female.
I have a SQL server stored procedure which updates, deletes and merges data into a table , how do I convert the stored procedure to pyspark job, is it possible to update a table in fabric using pyspark?, please make a video on this topic. thank you
This was a bit confusing. I'm not sure why we were changing names at the end, not right at the beginning.
Great episode guys. keep it up!
Why do I need to pay for a SQL Server instance to be running 24/7 when I only need it to run for an hour every day to feed Analysis Services? My company faced this exact situation. So we switched to SQL Serverless which turns off after a period of inactivity and saved $40k a year.
wow that is killer, and exactly my point!! There are better ways of doing things. more efficient and cost effective ways, Thanks for sharing.
I really love your conversations. I listen to this channel while my commute. I am a Junior Data Viz Consultant and these conversations are chnaging the way I see at my role and data literacy and adoption in general. Thank you so much for regularly conducting these conversations.
Thanks so much for sharing, and we are super happy we are expanding your thoughts on this. Please let us know if you have any additional topics you want us to discuss! Thanks for listening.
Hi, Since semantic link is GA, no need to put %pip install semantic-link at the top. Markus
Oh snap, We will need to do a follow up video, thanks for the info.
Sometime, I'll have to show you guys a little feature I've started adding to my reports: The Data Freshness Indicator -- a dynamic emoji that changes to indicates whether the data for the current day has been successfully refreshed in both the Data Warehouse and the Semantic Model, with a tooltip that explains what each of the possible emojis means.
Great content 👍One thing that we are looking into is using Git to deploy a change to multiple workspaces. We have a workspace for each customer and the workspaces only differ in the database connection (Azure SQL mirrored database). So same data model, same reports but with different data for each workspace. Do you know if this Git mechanism capable for that. In my mind the different workspaces would all point same source branch and the same folder. Only the data connection would be somehow parameterized.
The solution is absolutely not scalable, and it actually should be in the first place. Those tests with hardcoded values will become meaningless as soon as the report is run in production environment, which is supposed to contain completely different data. Everything that has been shown here contradicts the CI/CD principles, I don't know why you even brought up that term.
Can perspectives not be a solution for the mega, overwhelming model?
might be part of the solution, I like how you are thinking!
Hi Steph and Mike. This is fantastic news! I went through this last week and ended up with spark dataframes. The error message was elusive but I did get a column mapping error at one stage. You have nailed it with the json metadata. Thanks for this, it has given me some confirmation that I'm not the only one baffled by fabric!👍
Fantastic! We felt like others need to know about this work around more news on this coming.
Every time Carly says "Metrics Layer" my brain hears "Metric Slayer" 🤘😎🤘
lol, and the Metal Heads rock out!
I think a nice feature to have would be a measure view (like the query view in Power Query) to enable the developer to see the hierarchy of measure dependencies.
You can do it with PowerOps tool
Nnnm
All Power BI developers will forever be grateful for this overview! Thanks a lot, Mike and Zoe
My 'Create chart' button is grayed out. Any ideas?
24:30 Role shifts topic starts here
Great demo, Thanks a lot! any chance to load the video with better quality, maybe 1080?
i love You ...
With Metric Set can we reuse the common dimensions in other semantic models?
In embedded analytics, do we need to use a semantic model or Metric set to create the embedded token?
Can we add a calculation group and field parameters in the metric like any other dimension
I have multiple excel (not csv but xlsx) formatted files in a folder and they have extra rows with details that needs to be removed before promoting the relevant row to headers. How can i loop through these files in Fabric and apply the same transformation using DFGen2 then load to delta table?