Power BI External Tool to run automated checks in a report - flavio-meneses/PBIAutomatedChecks: Power BI External Tool to run automated checks in a report

In this article, we tackle the growing issue of ‘report-specific objects’, dataset measures and tables created to fill specific report visual requirements, why they negatively impact self-service users, and best practices to mitigate this impact.

Discussions with clients regarding the performance of their data models in Power BI have been a frequent occurrence for me recently. The issues often involve failed refreshes, queries that run slow…

Using thr char gpt api and tabular editor you can now add business descriptions to your dax statements.

A finance user case The Star Schema methodology is the application of dimensional modelling techniques to a relational database. This includes not only simple star shaped models, but a wide range of techniques such as snowflaking or factless fact tables. These principles should (almost always) be adopted in Power BI (a relational-like database). This article discusses one of the exceptions; dealing with subtotals.

A tool for customizing and dynamically generating a tabular model from an existing tabular model. - m-kovalsky/MiniModelBuilder: A tool for customizing and dynamically generating a tabular model fr...

Helpful intro for Windowing Functions

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…

Mathias has published some demos and demo data on GitHub: https://github.com/pbi-toolsIn this video he shows how to get started with them and what do you have.

A lot of people are building large datasets in Power BI Premium nowadays, and if you’re building a large dataset you’re very likely to be using Power BI’s incremental refresh func…

You can schedule a Power BI Dataset to be refreshed at any time you want using Power Automate to do this for you!

DataOps Principle #16 - Monitor Quality and Performance

This post is part of a series about specifications, requirements, work items and test-cases in the field of Business Intelligence solutions. First part is about why I hate and I’d not recomme…

Tips and tricks for asking questions with Q&A in Power BI

In this blog I show how to use PowerShell to automate the processing of multiple Power BI partitions, which is faster.

One of the things that has intrigued me in the Power Query docs for a while now is the Expression.Evaluate() function, which takes some text and evaluates it as a Power Query expression (rather lik…

If you’re interested in performance-tuning a Power Query query, you’re going to need a reliable way of telling how long your query takes to run. It’s not as easy as it seems to adapt your query to …

Level: Intermediate–Advanced I have covered the topic of Lineage in DAX a few times in the past (within other articles). Today I thought I would write a single post dedicated to lineage. As you may kn…

by Avichal Singh Now that Rob has acquainted us all with the Power BI family, I wanted to take a closer look at one of the relatively new members: Natural

How can I use the Power BI Q and A? What are some helpful tips for using it? Are there any limitations? What sort of visualizations are available? Can I pin the visualizations to dashboards?

Power BI Natural Language Q&A looks great in demos; mind blowing in fact. Just type in any question and get your answer right away! Can’t get any bette

Last time, we gave you the best case scenario for Q&A against a "raw" data import. However, in order to successfully understand the large swath of questions it is capable of interpreting, Q&A makes a number of fundamental assumptions...

We’ve heard from customers that SharePoint Online is a critical part of their company’s data communication and dissemination strategy and that to-date it wasn’t easy to include Power BI content there. The feature we’re announcing today changes all that.

Asking Q&A Questions relating to dates or times   The one thing that I think a lot of people do not realize that Q&A is aware of dates and times.   And by that I mean that Q&A knows when you mean today, it is today’s current date.   It’s always easiest to show with an example.      As you can see a...

Q&A (Natural Query Language) is by far one of the features that I find really gives the WOW factor when showing people the capabilities of Power BI. And in my opinion it is awesome. So I though…