Power BI

You might have seen the recent YouTube video by Guy in a Cube, where Adam explains how to work as an external user and publish content from Power BI Desktop to a B2B workspace. In this blog, I will…

How to use people analytics to improve workforce productivity, engagement and wellbeing. Make data-driven decisions in HR departments.

If you want to: Present interesting Power BI discoveries to your colleagues Test your DAX Measures, reporting on a very clean Star schema Discover multiple DAX Functions Show different Power BI features by examples Then this Lazy DAX file is for you! It’s a Power BI Desktop file that you can freely download on my […]

There are several updates coming to email subscriptions that use full report attachments that we want to make you aware of, including extending the maximum length of reports to 50 pages, appearance in the Gen2 metrics app, and deprecation in the original version of Power BI Premium.

The most exciting (at least for me) feature in the new Enhanced Refresh API (blog announcement | docs) is the ability to cancel a dataset refresh that’s currently in progress. Up until now, a…

In this blog post we'll explore how to trigger a Power BI Dataset via Azure Synapse Analytics in 3 simple steps: Step 1: Create a new security group called “AzureSynapsePowerBIIntegration” in your Azure Active Directory. Next add the name of your Azure Synapse Workspace as a member of your new security group. This will be

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…

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 …

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.

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.

Picture this, you have a report in Power BI that someone passes off to you for data quality checks. There are a few ways to make sure your measures match what is in the source data system, but for …

Last year, I wrote a blog on how to build a nested complex Data Model using BigQuery , please read it first, unfortunately using standard SQL to nest and unnest Data was a painful exercise, maybe i…

Introduction to datamarts5 minutes to read3 contributorsBusiness users rely heavily on centrally governed data sources built by information technology teams (IT), but it can take months for an IT …

Training users is important in every Power BI project. It’s particularly important when implementing Power BI, or if users are not familiar with Power BI reports. However, creating good training material is time-consuming, and difficult. In this article, I introduce reporTee, a licensed, out-of-the

Dataflows are an important component in the Power BI architecture. Using them can enhance the development and maintenance of your Power BI solution significantly. However, there are many Power BI …

Describes enhanced refresh by using the Power BI REST API

In our previous Power BI automation blog, we utilized the Power Platform in combination with Azure SQL to store refresh history of our datasets leveraging the Power BI REST API when on a Power BI shared capacity. A solution to manage Power BI dataset refreshes is particularly useful when data source refresh times are variable and end users need to know when dataset refreshes are successful. However, Power Automate and Azure SQL create two failure points. This solution also requires additional licensing cost in Power Automate to leverage premium data connectors to Azure SQL. So, how can we consolidate the number of tools we use and at the same time leverage the security features and access controls that Azure provides?

Learn how to set up Apps in Power Bi to elevate the user experience giving your reports a professional interaction.

Tired of slow and inefficient data refresh process? Learn how to leverage Incremental refresh feature to speed up and optimize the data refresh!

Another week, another challenge! Summer holidays is the perfect time to run into challenges that you normally would not encounter or simply do not know about because they are fixed before you know.…

Join the public preview to enable additional settings for workspaces in Power BI

Struggling to choose the right virtual machines for your Power BI Gateways? Worry no more with this insightful blog that will help make the decision easier.

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…

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

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…

If you’ve read part 1 or part 2 of this series you’ll know how you can create a Power Automate custom connector to call the Power BI Enhanced Refresh API and get fine-grained control ov…

Being able to do a data driven report subscription with Power BI and Paginated reports is a common request we hear from many customers. Let’s say you want to send a PDF version of a report to…