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

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

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…

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

Natural language query was probably the most unused feature in Power BI, until they introduced the new Q&A visual in the end of 2019. I’m a huge fan of this feature, but it is sometimes a…

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

Good morning, Power BI Developer Let’s say you’re a BI developer within a corporate BI team and you’ve been assigned to a Power BI project. More specifically, you’re respons…

Self-Service Power BI Report Template The final task for the dataset designer in sprint 12 is to create a report template (.PBIT file) that will allow users to build their own reports in Power BI D…

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…

Mark V SQL - Mark Vaillancourt: Data Nerd

You can now use natural language queries in Power BI Desktop, using Q&A

In this post I show you how to document your SSAS Tabular Model in Power BI without writing DMVs. The tool made Power BI is free to download.

Regular readers of my blog probably get sick of hearing me rave about the latest new thing in Power BI. This month there is an absolute cracker – Q&A in Power BI Desktop. In case you don’t know, Q&A i…

Today, I found out about a Power BI Q&A feature that enables you to customize the visual appearance of your Q&A results. Treb Gatte shows this feature in a short video, but I would also like to presen…

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