Power BI

DAX is simple, but it is not easy. I cannot remember how many times I read this sentence on social media, attributed to me. For good reason: I have repeated

Instead of repeatedly creating similar objects in Power Apps, we can save a lot of time by using components. A good example I see in many apps is a dialog

Recently I’ve been working with a Dynamics 365 Sales Pro project. In addition to some Azure artifacts (e.g. Logic Apps) for integration and migration purposes, our delivery contained plenty o…

It is not uncommon that you need to get input from external parties as a step within your various business processes. You might need to collect approvals from stakeholders, for example. Or you need…

Typically, when you create a Power BI report, you provide the end user a view to the present and past time. For decision makers this rarely is enough, since decisions should be also based on predic…

In this tutorial, I’d like to discuss how you can improve your creativity when creating custom visual reports in Power BI. I highly recommend creating projects that are outside your organization’s environment. This is because when creating projects for your organization, your creativity is limited. M

A client had a problem with his report. I was asked to find the issue and solve it. This is the story about it

In a previous story, I explained some details about Semi-Additive Measures. Here are some more hints on this topic

In this article we show some techniques to force a measure to return zero instead of blank, in order to highlight combinations of attributes with no data. P

When I am working with the Power BI REST APIs I am regular visitor of the API documentation. I always learn a lot about the data when I am building a Power BI report so I thought it would be a useful exercise to create a Power BI version of the API documentation. If you […]

Have you ever wanted to export a table from Power BI Desktop into Excel just to make sure the DAX you’ve written is performing as expected but ran into this error message: “Data exceeds the limit – Your data is too large. Some data sampling may occur”? Most probably this has occurred because you’ve got […]

User Id or User Group based pages in Power BI report UI Our target is to make one report that has different pages to users depending on which AD groups they belong to. Alternative implementation methods Our requirement is simple and basic, but Power BI doesn’t support this type of solutions, so the ...

ADDCOLUMNS: Returns a table with new columns specified by the DAX expressions. https://dax.guide/addcolumns/

Learn how to push your report level measures into your tabular model!

How to create a Modern SharePoint Site using Power Automate with the help of the Send an HTTP Request to SharePoint action.

How the presence of nullable columns affects the way Power BI and Power Query generate SQL

Explore how to create custom groups based on a slicer selection in Power BI. For example, create two versions of a measure: one returns the value of the sel

Do you ever get the feeling that you you’re participating in a completely different conversation than the person you’re talking to? Maybe you are. Back in December[1], Power BI MVP Lars…

Learn how helpful can the add prefix and suffix in Power BI and Power Query can be. You will learn it through an example of generating URLs.

Today we are announcing updates to the Power Platform VS Code extension and the Power Platform CLI, check out the new features and give us feedback

The open source tool for packing and unpacking a Canvas app is now available in preview through the Power Platform Command Line interface.

Important updates for workspace admins and Power BI admins, we are extending the timeline for upgrading classic workspaces to new workspaces.

Have you been wondering how to measure the impact of different brands, persons, or organizations on Twitter? Now, you can. DataChant released a new Power BI app on Microsoft AppSource that allows you to search for any Twitter handle, hashtag, brand, or mentioned keywords and analyze their impact over time. The new app is our […]

Calculated tables are not used often, because after all, it only combines data that you already have, right? Well, I didn't use them often, until recently...

Lookups are a core component of model-driven apps, as they help bring underlying data relationships in Microsoft Dataverse to life. Advanced lookup helps end users explore and find that data easily, so they are more productive with data-entry tasks.

Calculation groups can apply specific calculations onto existing DAX measures. For example, calculation groups can implement time intelligence calculations

Dev Consultant Jean Hayes spotlights Data Analysis Expressions (DAX) with Calculation Groups. Power BI Premium (Preview), Azure Analysis Services and SQL Server Analysis Services 2019 now support Calculation Groups! Why am I so excited? Because this functionality was one of the best capabilities in Multidimensional Analysis Services through Named Sets and Calculated Members.

This story is intended to share small bits of code that I have found extremely useful in my day to day activities as a Power BI consultant.