Директ-ПРО // Новости Power BI. Страница 2

Managing Power BI tenant settings just got easier in Microsoft Fabric

If you’ve read the Power BI adoption roadmap or attended any of the full-day training sessions I’ve been doing with MVP Melissa Coates[1], you know how important it is to manage setting…

Copilot in Power BI Demo

With Copilot in Power BI, we are infusing the power of large language models into Power BI at every layer to help users get more done and create more value from their data. Using Copilot, you can simply describe the visuals and insights you’re looking for and Copilot will do the rest. Users can create and tailor reports in seconds, generate and edit DAX calculations, create narrative summaries, and ask questions about their data, all in conversational language. With the ability to easily tailor the tone, scope and style of narratives and add them seamlessly within reports, Power BI can also deliver data insights even more impactfully through easy-to-understand text summaries. Learn more about Copilot in Power BI in the announcement blog: https://aka.ms/Fabric-PBI-Blog Follow us on Twitter - https://twitter.com/mspowerbi More questions? Try asking the Power BI Community @ https://community.powerbi.com/ #microsoft #microsoftpowerbi

Introducing Microsoft Fabric and Copilot in Microsoft Power BI

Today, we are excited to unveil Microsoft Fabric and Copilot in Microsoft Power BI. Fabric, now in preview, is an end-to-end, human-centered analytics product that brings together all an organization’s data and analytics in one place.

Power BI Dev Camp Session 32 - Design Guidelines and Best Practices with Power BI Embedding

The March session of Power BI Dev Camp examines important design issues and decisions that arise when developing with Power BI embedding. The session begins by comparing the User-Owns-Data development model with the App-Owns-Data development model and describes scenarios most appropriate for each. This session will examine best practices when developing with App-Owns-Data in terms of authentication, authorization and provisioning content in a multi-tenant environment. The session will also cover other Power BI embedding best practices including when to use service principal profiles, enabling self-service report authoring and securing data with RLS. What Campers Will Learn: How to choose between User-Owns-Data versus App-Owns-Data How to authenticate and authorize users with App-Owns-Data embedding Best practices in building a multi-tenant environment and provisioning content Why, when and how to integrate service principal profiles into your application design Adding self-service support for creating and editing embedded reports Programming with EffectiveIdentity to secure data using Row Level Security (RLS) Capturing telemetry data and monitoring usage with App-Owns-Data embedding Session Prerequisites Campers should already be familiar with the fundamental concepts and basic programming associated with Power BI embedding. Follow us on Twitter - https://twitter.com/mspowerbi More questions? Try asking the Power BI Community @ https://community.powerbi.com/ #microsoft #microsoftpowerbi

ChatGPT blew my mind with this Power BI scenario

Our minds were blown by this ChatGPT example for Power BI from our friends Stephanie Bruno and Shannon Lindsay! Use ChatGPT to help get you pointed in the right direction and with a faster solution. Power BI datasets CI/CD (the easy-ish way) https://data-witches.com/2023/03/31/power-bi-datasets-ci-cd-the-easy-ish-way/ Stephanie Bruno https://twitter.com/StephTBruno https://www.linkedin.com/in/brunostephanie/ https://data-witches.com Shannon Lindsay https://twitter.com/shan_gsd https://www.linkedin.com/in/shannonrlindsay/ https://data-witches.com 📢 Become a member: https://guyinacu.be/membership ******************* Want to take your Power BI skills to the next level? We have training courses available to help you with your journey. 🎓 Guy in a Cube courses: https://guyinacu.be/courses ******************* LET'S CONNECT! ******************* -- http://twitter.com/guyinacube -- http://twitter.com/awsaxton -- http://twitter.com/patrickdba -- http://www.facebook.com/guyinacube -- https://www.instagram.com/guyinacube/ -- https://guyinacube.com ***Gear*** 🛠 Check out my Tools page - https://guyinacube.com/tools/ #PowerBI #ChatGPT #GuyInACube

Calculating Averages Per Weekdays or Weekends Using DAX In Power BI [2023 Update]

The AVERAGEX function in DAX is used to calculate the average of a set of numeric values in a table or expression that results in a table. It is useful in Power BI reports when you need to calculate an average for a group of values based on a specific condition, such as average sales per customer. To maximize the function, use it with a filtered table or expression, consider using it with other DAX functions, and be mindful of performance with large data sets. This also showcases how adaptable iterating formulas are in DAX. In this video, Sam will showcase how you can utilize AVERAGEX for calculating averages per weekdays. *****Video Details***** 00:00 Introduction 00:30 Average Sales per Day 01:57 Average Sales per Weekday 04:40 Average Sales per Weekend 05:40 Average Sales Difference ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax FREE - Power BI Resources - www.enterprisedna.co/power-bi-resources Enterprise DNA On-Demand - app.enterprisedna.co Enterprise DNA Subscription - app.enterprisedna.co/pricing Enterprise DNA Events - www.enterprisedna.co/events #EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

DAX Pareto Calculation - Phil Seamark on DAX

I always enjoy it when we get new DAX functions, especially so for the new set of WINDOW Functions recently added. As part of the April 2023 release of Power BI Desktop, we now have a RANK function and the ability to use a measure to control the order within the existing WINDOW function. The … Continue reading DAX Pareto Calculation

Identifying CPU and memory-intensive Power Query queries during refresh in the Power BI Service

See how much CPU and memory Power Query uses when refreshing a table in Power BI

IF.EAGER Function in Power BI

We have several conditional expressions, such as the IF and IF. EAGER function, in Power BI. The IF. EAGER function is a logical function whose primary role is to check if a condition in a set of data has been met or . . If the condition in question is true, then the logical expression

Optimizing fusion optimization for DAX measures

How to implement a DAX measure to run faster than what you get from the built-in horizontal fusion optimization. Article and download: https://sql.bi/792359?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-definitive-guide-to-dax-2nd-edition/?aff=yt

5 Best Practices in Power Query

In this video, we will learn about some best practices that can help us to be more efficient & smart working on Power Query! Join this channel to get access to perks: https://www.youtube.com/channel/UCQ_R6vwEXkFAlw0X4P-znbw/join ===== ONLINE COURSES ===== ✔️ Mastering DAX in Power BI - https://goodly.co.in/learn-dax-powerbi/ ✔️ Power Query Course- https://goodly.co.in/learn-power-query/ ✔️ Master Excel Step by Step- https://goodly.co.in/learn-excel/ ✔️ Business Intelligence Dashboards- https://goodly.co.in/learn-excel-dashboards/ ===== LINKS 🔗 ===== Blog 📰 - https://www.goodly.co.in/blog/ Corporate Training 👨‍🏫 - https://www.goodly.co.in/training/ Need my help on a Project 💻- https://www.goodly.co.in/consulting/ Download File ⬇️ - https://goodly.co.in/5-best-practices-power-query/ ===== CONTACT 🌐 ===== Twitter - https://twitter.com/chandeep2786 LinkedIn - https://www.linkedin.com/in/chandeepchhabra/ Email - [email protected] ===== CHAPTERS ===== 0:00 Intro 0:23 1 - Name the Steps 1:59 2 - Write Comments for Complex Transformations 3:54 3 - Notice and Omit the Red 7:11 4 - Parameterize and Stage the Queries 9:15 5 - Quick Access Toolbar 10:35 My Courses ===== WHO AM I? ===== A lot of people think that my name is Goodly, it's NOT ;) My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI. Please browse around, you'd find a ton of interesting videos that I have created :) Cheers!

Checking out the new Power BI RLS Editor

Take a look at the new Row-Level Security (RLS) editor within Power BI Desktop! Patrick explores how it works and what to look out for in the Preview. Power BI February 2023 Feature Summary https://powerbi.microsoft.com/en-us/blog/power-bi-february-2023-feature-summary/ Documentation https://learn.microsoft.com/power-bi/enterprise/service-admin-rls#define-roles-and-rules-in-power-bi-desktop-using-enhanced-row-level-security-editor-preview 📢 Become a member: https://guyinacu.be/membership ******************* Want to take your Power BI skills to the next level? We have training courses available to help you with your journey. 🎓 Guy in a Cube courses: https://guyinacu.be/courses ******************* LET'S CONNECT! ******************* -- http://twitter.com/guyinacube -- http://twitter.com/awsaxton -- http://twitter.com/patrickdba -- http://www.facebook.com/guyinacube -- https://www.instagram.com/guyinacube/ -- https://guyinacube.com ***Gear*** 🛠 Check out my Tools page - https://guyinacube.com/tools/ #PowerBI #RLS #GuyInACube

DAX Studio Server FE Benchmark - Unplugged #51

DAX Studio can measure the performance of your DAX engine so that you have a baseline to compare the query execution time on different computers or servers. IMPORTANT: as a preview feature, you must enable it by using "Show the FE Benchmark button" in Options / Preview! Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021/01/09/the-unplugged-video-series-on-sqlbi-youtube-channel/?aff=yt #unplugged #daxstudio

How To Track Sales Trends Through Time In Power BI Using DAX [2023 Update]

Understanding how to track sales trends through time in Power BI is crucial for businesses as it helps them make data-driven decisions and identify opportunities for growth. By creating clear and intuitive visualizations, users can analyze sales trends and patterns more effectively. Mastering this skill in Power BI can enable businesses to optimize their performance and maximize profitability. In this tutorial, Sam is going to showcase how you can track sales trends through time in Power BI using DAX. *****Video Details***** 00:00 Introduction 02:10 Quarterly sales growth 03:35 Product growth 04:31 Conditional formatting 05:45 Monthly tracking 07:03 Other applications ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax FREE - Power BI Resources - www.enterprisedna.co/power-bi-resources Enterprise DNA On-Demand - app.enterprisedna.co Enterprise DNA Subscription - app.enterprisedna.co/pricing Enterprise DNA Events - www.enterprisedna.co/events #EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial

How To Use Conditional Formatting Based On String Fields - Power BI February 2023 Updates

In this video, Brian is going to share one of the new features in the Power BI February 2023 Updates — the Conditional Formatting Based On String Fields. This new feature has been added to allow users to set conditional formatting rules based on string fields, which was highly requested. This new capability can be accessed through the formatting pane dialog, allowing for conditional formatting of column chart colors, among other things. Watch as Brian demo this new feature. *****Video Details***** 00:00 Introduction 01:06 Data set 01:34 Conditional formatting 02:35 Field value 03:34 Advantages in using SWITCH TRUE 05:29 Text operators 05:58 Complex conditions 06:23 Dynamic highlighting of outliers 08:04 Summary ***** Related Links ***** Power BI February 2023 Feature Summary - https://powerbi.microsoft.com/en-cy/blog/power-bi-february-2023-feature-summary/ Brian's Color Cheat Sheet - https://www.linkedin.com/posts/brianjuliusdc_power-bi-named-colors-cheat-sheet-activity-6997643202631450624-1lng ***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - www.enterprisedna.co/courses/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - www.enterprisedna.co/courses/ultimate-beginners-guide-to-dax FREE - Power BI Resources - www.enterprisedna.co/power-bi-resources Enterprise DNA On-Demand - app.enterprisedna.co Enterprise DNA Subscription - app.enterprisedna.co/pricing Enterprise DNA Events - www.enterprisedna.co/events #EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerBIFebruary2023Updates

Power BI and PowerPoint: A Powerful Combination for Data Visualization is now generally available

We are happy to announce the general availability of Power BI integration with PowerPoint. This integration makes presentations more engaging and informative by allowing users to create rich, interactive visualizations that can be embedded in PowerPoint slides. The is now available also in national clouds. The integration has also added new features such as the ability to use a single visual, leverage Smart Insights to generate text that summarizes the data in the slide, and a “What’s new” banner to keep users informed of new capabilities.

Export Power BI data to any format: excel, power point, pdf, xml, .....

interested in other ways to export data? Check the playlist: https://www.youtube.com/playlist?list=PLDz00l_jz6zze26MVT-0YV7qcjismMFFo Join this channel membership to get access to all the recorded bites as they become available: https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw/join Here you can download all the pbix files: https://curbal.com/donwload-center SUBSCRIBE to learn more about Power and Excel BI! https://www.youtube.com/channel/UCJ7UhloHSA4wAqPzyi6TOkw?sub_confirmation=1 Our PLAYLISTS: - Join our DAX Fridays! Series: https://goo.gl/FtUWUX - Power BI dashboards for beginners: https://goo.gl/9YzyDP - Power BI Tips & Tricks: https://goo.gl/H6kUbP - Power Bi and Google Analytics: https://goo.gl/ZNsY8l ☼☼☼☼☼☼☼☼☼☼ POWER BI COURSES: Want to learn Power BI? How about you take one of our courses? Here you can find the available courses: https://curbal.com/courses-overview ☼☼☼☼☼☼☼☼☼☼ ABOUT CURBAL: Website: http://www.curbal.com Contact us: http://www.curbal.com/contact QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here: Linkedin ► https://goo.gl/3VW6Ky Mastodon ► @[email protected] Twitter ► @curbalen Facebook ► https://goo.gl/bME2sB #CURBAL #SUBSCRIBE

Multitasking in Microsoft Teams with Power BI is getting better

The Power BI app for Microsoft Teams, Outlook, and Office is getting updated multi-tasking experiences to help users complete their tasks faster. Read the blog for all the details.