Power BI

Welcome to the October 2022 update. This month’s update is packed with exciting updates to features like Power BI metrics, Modeling, Deployment pipelines, and more. Please read on for all the details, and feel free to leave your thoughts in the comments below the post. We would love to hear from you!

I’m thrilled to be co-presenting a full-day pre-conference session with the one-and-only Matthew Roche. We’ll be presenting our all-day session live and in-person in Seattle, Washington on Tuesday, November 15, 2022 at the PASS Data Community Summit.

Probably one of the most annoying things about creating bookmarks is... updating them! However, there is a trick that will make your life so much easier and the process a lot faster. And the trick is... GROUP YOUR VISUALS and always select the option "SELECTED VISUALS" when creating your bookmark Let me get into the details now... The steps you need to do for this technique are: Group the visuals/shapes in your report (create kind of reporting areas) Using the Selection Pane, select the grou

3 simple but powerful Context Transition Examples . Covering- Calculate Sales for Best Selling Day of the Month, Calculate Best Selling Product's Sales Value & Calculate Best Selling Region's Sales Value

Learn about the importance of dimensional modeling when building reports and analysing data, as well as how it works in Power BI

SELECTEDMEASURENAME: Returns the name of the measure that is currently being evaluated. https://dax.guide/selectedmeasurename/

We’re excited to help more users quickly communicate insights by helping users share links to charts and updating how users copy images of visuals. This can empower more people to use data in their decision making using the communication tool of their choice. Read all the details in this blog.

Want to hear more about using the #PowerBI Adoption Roadmap? Join me and @SQLAllFather on Tues, Nov 15th (virtually or in-person). We'll focus on the most impactful things you can do to increase your adoption maturity level.My blog post with more info: https://t.co/cnuH7jWE3B pic.twitter.com/dpZ0RxPPwm— Melissa Coates (@SQLChick) October 31, 2022

This article covers Checks, User Interactions and Annotations in C# Scripts because they are basic building blocks of more complex scripts.

Do you have a a large dataset in Power BI Premium or Premium Per User? Do you have more than six tables that take a significant amount of time to refresh? If so, you may be able to speed up the per…

A blog about Power BI, SQL Server Analysis Services (Multidimensional and Tabular), MDX, DAX, Power Pivot, Power Query, M, Power Map and Excel for BI

Hi everyone! Quick method to save a bit of report space by using shorter names for date granularity selection within the slicers 🔎🔎 Following example refers… | 13 comments on LinkedIn

Where to deploy your Power BI Report? My Workspace? Regular Workspace? What about Apps? Adam breaks it down to help you make the right choice and understand why it matters!

Problems with non-additive DAX calculations

Hope you’re all enjoying the fall! With the changing of the leaves comes a changed on-premises data gateway. Download the October version to use the same query execution logic/run-time as in the October version of Power BI Desktop.

A common question is why Power BI totals are inaccurate because they do not display the sum of individual rows. In this video, we explain the reasons why th

Learn about an up and coming external tool that makes it easy to identify and KILL unused measures and columns from a Power BI dataset (PBIX). Gregor Brunner will walk us through how to use this great tool, how it works, and more. Tune in to find out! Video by: Reid Havens

In this blog, we’ll cover the importance of gathering event activity data, and how to utilize the REST APIs effectively to do so.

In the July blog post about the Ideas site, we published our plan to improve the Ideas website. Today we would like to share some of the progress as well as a roadmap for Ideas.

Prediction: 9/10 communities will fail. Why? Because there's no intentional community design baked into the vision. This can help 👇🏽 pic.twitter.com/MJHS0Ex3lr— Milly Tamati (generalist.world👾) (@MillyTamati) October 4, 2022

One of the main challenges I see #powerbi admins of large enterprises is monitoring & troubleshoot all their on-prem Gateway Clusters. Each cluster has multiple gateway servers that are responsible to connect the Power BI service in the cloud to customer data sources, sometimes there are errors in t

Report powered by Power BI

The October release of PowerBI Desktop introduced a very interesting feature, Top N filtered is pushed down for Direct Query Sources, I thought I may give it a try and blog about it, for some reaso…

Announcing submetric roll ups in Power BI Metrics: automatically aggregate submetric values to a parent metric, allowing less time updating data, and more time tracking performance.

In this writing, I like to share what I have learned about OFFSET DAX function, that recently came out to the world, but not yet documented on https://learn.microsoft.com/en-us/dax/ as of today. When I face the situation to measure date-intelligence-related business requirement, I use SAMEPERIODLASTYEAR, DATESINPERIOD, DATEADD, and so many other time intelligence DAX functions, if a business is using normal & general calendar table. Or, I use FILTER, MIN, MAX, and some other DAX functions, if

Power BI REST API custom functions. Contribute to tirnovar/Power_BI_REST_API_PQ development by creating an account on GitHub.

The Microsoft Ignite Book of News is your guide to key news items that we are announcing at Microsoft Ignite.

If you’re monitoring activity in Power BI, for example using Log Analytics, you’ll know that you can capture the DAX queries generated by your published Power BI reports. How do you mak…