Plenty to read!
All tagged Power Query
In this short article, we look at the consequences of having a case-specific collation in your Power BI semantic model. This is particularly important as Direct Lake models created in the Fabric user experience have a case-sensitive collation applied, automatically.
This short post explains how to format Power Query automatically in Tabular Editor using a C# Script to call the powerqueryformatter API.
Dataflows can be a very useful and powerful data transformation tool to centralize & govern transformation logic. In this article are some points to consider when making & deploying Power BI Dataflows in your organization.
In this post, we look at what we can do to make our datasets easier to use, understand & maintain.
A quick tutorial about how to add or modify static data tables (i.e. those created with Enter Data) using Tabular Editor 2 or 3.
Tabular Editor is not only a helpful tool for developing DAX. You can also use it to view & modify your Power Query M code, without ever opening Power BI desktop. Furthermore, there also exists a formatter for Power Query that can help you make your code easier to read & manage. Here, I walk through the basics, the use-cases, and a small tutorial on how to do this, yourself.
