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

What to know about the new accessible Power BI themes

In February 2023, Microsoft released some new Power BI themes that are more accessible than the other themes available by default. The blog post mentions the prevalence of color vision deficiency (…

How to get a CLOCK in your Power BI Report

We had a question about how to get a clock in Power BI? Is that even possible? Patrick takes advantage of the Deneb visual to make it happen! Vega Clock Sample https://vega.github.io/vega/examples/clock/ HTML Content Custom Visual Limitations https://www.html-content.com/reference/limitations Kerry Kolosko https://kerrykolosko.com/exploring-deneb-for-power-bi/ 📢 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 #Deneb #GuyInACube

Dataset permissions required for App report in Power BI? What am I missing???

Struggling with Power BI App permissions when using shared datasets? Adam looks at how this works. Even for PRO users!!! Composit model permission blog (Older information): https://powerbi.microsoft.com/en-us/blog/update-to-required-permissions-when-using-composite-models-on-a-power-bi-dataset/ 📢 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 #Permissions #GuyInACube

Publish/Migrate your RDL files from Power BI Report Server to the service

Using on-premises Power BI Report Server? You can now migrate your paginated RDL reports to the Power BI service from within the portal. Patrick shows you how! Plan to migrate .rdl reports to Power BI https://learn.microsoft.com/power-bi/guidance/migrate-ssrs-reports-to-power-bi Blog Announcement: https://powerbi.microsoft.com/blog/power-bi-report-server-january-2023-feature-summary/#post-21998-_Toc121395751 Public RDL files to Power BI https://learn.microsoft.com/power-bi/guidance/publish-reporting-services-power-bi-service?tabs=powerbi-report-server 📢 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 #Paginated #GuyInACube

Power BI Activity Logs: New Workspace Metadata for Excel Scenarios

We are announcing improvements to the Power BI audit logs that helps Power BI admins filter usage of Power BI data in Excel by workspace name and workspace id.

Reference an intermediate step from a different query in Power Query

Referencing a different query in Power Query will usually return the final step. But what if you want to fetch another step within that query?

New Functions in DAX in 2022

What is DAX? Data Analysis Expressions (DAX) is a formula expression language used in Analysis Services, Power BI, and Power Pivot in Excel. It is a programming language that is used throughout Microsoft Power BI for constructing calculated columns, measures, and custom tables. It is a compilation o...

Best Practice for Power BI Workspace Roles Setup

Power BI workspaces are not like the old days when we had Edit access and View access only. You have more options for roles in a workspace, and in my courses, I have found that many people have chosen the incorrect role without knowing what the role does. In this article, I'll explain all the…

Datatype Conversion in Power Query Affects Data Modeling in Power BI - BI Insight

In my consulting experience working with customers using Power BI, many challenges that Power BI developers face are due to negligence to data types. Here are some common challenges that are the direct or indirect results of inappropriate data types and data type conversion: In this blogpost, I explain the common pitfalls to prevent future … Continue reading Datatype Conversion in Power Query Affects Data Modeling in Power BI

Analyzing Plex Media Server Data using Power BI

Around a year ago I left Spotify and started using my locally hosted Plex Media Server to feed my daily music consumption. Since I spent much of the last 30+ years building an extensive CD and MP3 …

Power BI REST API; What it is and Why it is Important

Power BI REST API. What it is and why it is important You can interact with the Power BI objects in the Power BI Service through a set of APIs called Power BI REST API. The Power BI REST API can help automate tasks, build tools that work with Power BI, the configuration of Power…

DAX Fridays #218: Window functions in DAX explained with example

Window functions performs calculations in different groups of rows. Let me show you how and why this is powerful for DAX and Power BI: 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

Why You Should Take Advantage Of The DAX Table Constructor

In today's video, Greg showcases one of his most used DAX constructs which he thinks is often overlooked by the DAX community — the DAX Table Constructor. He’ll be showing you what it’s all about and some examples on how he used it on some of his real-world works. *****Video Details***** 00:00 Introduction 01:48 Table 1 03:18 Table 2 05:48 Single column 06:09 Multiple columns 06:52 Table 3 09:52 BASE example 11:00 GAMMA example 11:27 Text to Table example 12:19 XOR example ***** 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

Showcasing Trends Using Moving Average Techniques In Power BI [2023 Update]

A lot of time at a daily level the data is too busy to showcase trends in your analysis. In this tutorial, Sam explains how to use moving average DAX techniques to make data trends more visually striking in Power BI. He also provides tips for using moving averages to effectively communicate data insights in a compelling way. ***** Video Details ***** 00:00 Introduction 02:03 Sales last quarter 03:12 Moving averages 04:12 DATESINPERIOD 05:15 Moving average last quarter ***** 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

Wait! Using a Power BI Date slicer, what are my dates when using between?

Struggling to get dates when using a between date slicer, or a before, or after? Patrick walks through a straightforward way to get the date values when using a date slicer in Power BI! 📢 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 #PowerBIDesktop #GuyInACube

Searching for a Better Power BI Gen2 Capacity Analogy - DataVeld

Reading Time: 4 minutes The Power BI Gen2 capacity model significantly changed the way that Power BI resources are shared among multiple or reserved for individual customers. Attempting to draw a good analogy of how capacities work, however, leads to significant oversimplification. Simple analogies...

Content Endorsement in Power BI, Part 2, Endorsing Contents - BI Insight

In the previous post, I explained what content endorsement means in #PowerBI. In this post, how to enable #Certification in #AdminPortal and how to certify the contents.

Deep dive into Optimize ribbon and streamline your Power BI authoring

How does the Optimize ribbon, with Pause visuals, Refresh visuals, Optimization presets, and Performance analyzer, as well as Edit relationships in the properties pane work to streamline your authoring experience? Here are some scenarios they can help you with! 1. Make changes to an existing DirectQuery report without running queries until you are ready 2. Create new visuals without running a query until you are ready 3. Create measures in a DirectQuery model without the visuals refreshing until you are ready 4. Quickly edit relationships between DirectQuery tables 5. Quickly learn about and apply query reduction settings to your DirectQuery report 6. Adjust the query reduction settings to the level you need in your DirectQuery report 7. Quickly revert to the full interactivity after a data source change in your report