Power BI

Get started with Power BI datamarts- Create a Power BI datamart in minutes!

We’re very excited to announce that the Power BI integration in Dynamics 365 and model driven Power Apps, which shipped as a preview last December, is now generally available. Dynamics 365 and model driven Power Apps give organizations the ability to quickly build essential line-of-business apps in a low-code environment, increasing agility and modernizing processes. Since these apps are all built on top of Dataverse, they’re backed by your core business data. With this integration directly on views, information workers are now able to tap into this data and explore it using Power BI’s powerful data analytics capabilities without ever needing to leave their app. Just click the ‘Visualize this view’ button and let Power BI automatically create a report on top of the exact data you were looking at.

Power BI APIs can support you at any scale, but there is no one-size-fits-all API. The ExecuteQueries API is a great choice at small scale. For large-scale solutions, switch to XMLA endpoints and host your datasets on Power BI Premium.

A few years ago we created a code sample for enterprise developers called Customer Orders Database, designed to demonstrate how developers can create

Use products table to find missing values in the fact table. Find Missing Products that did not sell.

List.Accumulate is a powerful function that allows you to perform transformation multiple times. Learn how its use can save you many steps!

On the surface it may look like Microsoft’s data gateway provides an even playing field between IaaS and PaaS approaches with regards to SQL hosting, i.e. you can run your database server in …

I’ve been spending time lately trying to get a deployment pipeline to work for one of my clients and ran into a couple of non-intuitive limitations that I didn’t expect, so I thought th…

When you want to return arrays from a flow in Power Automate to an app in Power Apps you could use the Response action, however this requires a premium

In this blog post we will learn how to create a left navigation component in PowerApps "the vertical menu" and how to use component in PowerApps ?

OnStart property not visible in Canvas apps, Onstart property of the app not available in Power Apps canvas apps

The improvements to the Power BI experience in Excel include a new user-friendly UI that helps users easily search for datasets to build reports in the Excel grid. Also, users can now directly navigate from Excel to the Power BI service to discover new data artifacts in their organization or get additional insights from Power BI reports.

Some time ago I wrote a post about how optimising for CPU Time is almost as important as optimising for Duration in Power BI, especially if you’re working with Power BI Premium Gen2. This is …

We can use the powerful new find & replace tool to quickly rename variables and collections in Power Apps across the whole app.

This article describes how to hide measures from a group of users by leveraging object-level security in Power BI and Analysis Services. Power BI datasets a

We are excited to introduce the Azure Data Factory studio preview experience, where users can try new UI updates and provide feedback!   You may have seen a new banner in your data factory:     Or a new option in your data factory settings:     By enabling the studio preview experience, you’ll be ...

A step by step guide o perform pagination in azure data factory or Synapse using Rest API

Work: 17th Century Watercolors

Its about the clusters. I have created a scatter chart with the measure of Profit Margin and Revenue of y and x axis respectively.

Creating a calendar is not as complicated as you think. It requires some creativity and you could achieve it too.

In post 4 of this week, we’re going to look at how you can utilise the components community members share! There are loads of Power Platform community contributors that share their created components which you can use in your Canvas Apps. Generally contributors will post these in their GitHub reposi

Are you using Power Apps triggered flows when creating Canvas Apps? In this post we’re going to look at how you can trigger a notification back to your user to let them know that a flow has run successfully. For example, we might have a function in our app to send an email, we’re going to add capabi

Introduction One of the diagrams that I use the most is the “Conceptual Diagram”. Which is a graphical representation of the building blocks or features that we are implementing using Dynamics 365.…

How to restore deleted Power Automate flows

Summary of the updates on Azure Data Factory in June 2022

You may have used the UNICHAR() function in DAX to return Unicode characters in DAX measures. If you haven’t yet read Chris Webb’s blog post on the topic, I recommend you do. But did yo…