Power BI

Do you want to return the next working day in Power Query? There is no build in M-function for this, but this post shows how to create one yourself!

Introduction A key requirement for strong Power BI governance is being able to easily report on usage from logs. There are many ways of getting logs in Power BI and many blogs looking at the variou…

In 2015-2016, a team of folks at RJMetrics had the opportunity to observe, and participate in, a significant evolution of the analytics ecosystem. The seeds of dbt were conceived in this environment, and the viewpoint below was written to reflect what we had learned and how we believed the world should be different. dbt is our attempt to address the workflow challenges we observed, and as such, this viewpoint is the most foundational statement of the dbt project's goals.

A new user experience will soon be provided in the landing page of adf.azure.com or Switch Data Factory tab of Data Factory Studio portal to enable users to create Data Factory with only one click! This will allow users to create a Data Factory that can be available within several seconds. This new ...

Today, we’re excited to announce the preview of Microsoft Dev Box is now available to the public. Microsoft Dev Box is a managed service that enables developers to create on-demand, high-performance, secure, ready-to-code, project-specific workstations in the cloud.

The Microsoft Intelligent Data Platform, empowers organizations to invest more time creating value rather than integrating and managing their data estate. It integrates best-in-class solutions across Microsoft’s technology stack—breaking down data siloes and enabling organizations to extract r...

When I'm developing reports, I'm asked multiple times to "hide" the slicers/filters from the report page. Usually this is to make space in the page for other visuals and because customers don't want to use the filter pane for some reason. This happened so many times, and only in the last couple of months I decided to try some things out and get a bit creative with Power BI. I came up with two solutions, which I think work great in these scenarios. Remarks: - This might not working very well if y

I spend a lot of time going through the Power BI documentation to find answers about Power BI features. As always, I look for opportunities to make my life easier when I need to look through of data. What better tool for this than Power BI itself? So, I created a few reports to help

In this article we will build a custom Power BI visual from scratch, we will build a KPI card with selections (interactivity in the…

Building a Custom Power BI Visual from scratch (KPI Card) In this article we will build a custom Power BI visual from scratch, we will build a KPI card with selections (interactivity in the dashboard), drill-through functionality, formatting options and highlighting. The code changes are kept to a m...

A key feature to optimize your #powerbi dataset refresh is to partition your dataset tables, this will allow a faster & reliable refresh of new data simply because with partitions you can divide the …

It started with @shan_gsd‘s tweet about Year 2022 Week 33 of the Workout Wednesday and @CJMajka‘s reply “A dumbbell chart in #PowerBI?! That is kind … Read More

One feature of Power BI incremental refresh I’ve always been meaning to test out is the ability to create your own M queries to work with the “detect data changes” feature, and la…

Refresh specific tables in your Power BI dataset using a Power Automate custom connector

I love the new Power BI Enhanced Refresh API: it allows you to do things like refresh individual tables in your dataset, override incremental refresh policies, control the amount of parallelism, ca…

This article describes the IN operator in Power Query. It checks whether a value equals one of many and is meant to simplify your code.

If you’re reading this blog, odds are you’re already familiar with the Power BI documentation. If there’s a feature in Power BI, there are a set of articles that describe its capa…

This post is a running collection of tools that I use for formatting and highlighting code in my blog. The code that I share mainly pertains to Power BI, but includes also Python and C#.

In this post, I explain why External Tools are necessary & discuss the challenges in adopting them.

This post describes the purpose of Coalesce and shows how you can simplify your M-expressions by removing unnecessary code.

Collect feedback on the Power BI report pages

Contribute to PowerRobin/PCF development by creating an account on GitHub.

Collaboration controls (Preview) enable you to easily add M365 capabilities to your Power Apps line of business custom applications to simplify user workflows when collaborating on business processes in Teams or Power Apps.

We are excited to announce the release of Canvas apps creation as Dataverse solutions by default in public preview

The new Power Apps grid control in model-driven apps is officially in public preview! This control can be used for both read-only and editable scenarios, supports infinite scrolling for a modern browsing experience, and allows pro-dev makers to customize the appearance of cells. Try it out today!

We are happy to announce a new version of the Power Platform Build Tools (Azure DevOps tasks) and our monthly update to Power Platform CLI. Read on for significant new features coming this month, including: Power Platform Build Tools: Now based on Power Platform CLI New CLI command to assign user New CLI command to … <p class="link-more"><a href="https://powerapps.microsoft.com/en-us/blog/new-version-of-power-platform-build-tools-and-a-feature-packed-update-of-power-platform-cli/" class="more-link">Continue reading<span class="screen-reader-text"> “New version of Power Platform Build Tools and a Feature packed update of Power Platform CLI”</span></a></p>

Reliable error handling moves to preview for Power Fx and Power Apps. You now have all the tools you need to detect, replace, report, and log errors, including a good default behavior if you never take advantage of these tools. And, bonus, you can also now write blank (or null) values to databases.