developer

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.

Genie Framework improves Spark Pool utilization by executing multiple Synapse notebooks on the same spark pool instance. Uses vaccum and optimize to maintain efficient delta tables.

Using optimize and vaccum to removed unused delta patition files. Helps maintain a minimized delta table size footprint.

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.

Power BI Desktop sample files for the monthly release. Here you can find the PBIX files used in the monthly release videos. Power BI Theme Files

Implementing Data Contracts for Entities

Learn how to create a Custom Page Dialog for Model-Driven Apps with this Task Generator example. Generate consistent Tasks but the user decide which will be generated!

Learn about the Power BI modules and Cmdlets for Power Shell, why using it, and examples of using these in real world scenarios.

It just got easier to create multi-language reports for Power BI.

Pre-computing aggregates from granular data to improve live performance for end users by using computing resources at scheduled times is a well-established software pattern. In this entry we'll look at how to set up aggregations across Microsoft business intelligence products. This functionality breaks the pattern of how most features have flown through the genealogy of

Learn about what is the Power BI REST API and how it can be used and what are the useful scenarios of it with links to study materials.

Our cool new house needs one more plank in its foundation.

Metrics layer is the rising “missing component” of the modern data stack. I dive into functionalities provided by 10 prominent players in the space and contrast them with a player no on…

Bug-free development with BDD. ✓ Automate tests in your native language ✓ by using the easy to understand Gherkin syntax. ✓ for .NET.

Being able to construct DAX queries dynamically in C# means the possibilities are endless in terms of integrating Azure Analysis Services queries into your custom applications, and with the code samples in this post, you have everything you need to get started.

An introduction to the basic syntax of Rel.

Despite being inherently difficult to test, the need to validate data modelling, business rules and security boundaries in Power BI reports is important, as well as the need for ensuring that quality doesn't regress over time as the insights evolve. This post explains that, by connecting to the underlying tabular model, it is possible to execute scenario-based specifications to add quality gates and build confidence in Power BI reports, just as any other software project.

With a variety of integration support through client SDKs, PowerShell cmdlets and REST APIs, it can be hard to know where to start with integrating Azure Analysis Services into your custom applications. This posts walks through the options, and lays out a simple guide to choosing the right framework.

One of the first steps in integrating Azure Analysis Services into your applications is creating and opening a connection to the server - just like any other database technology. This post explains the ins and outs of creating Azure Analysis Services connections, including code samples for each of the key scenarios.

Get connection string for localhost pbi file · GitHub