service

Power BI just launched a new Known Issue page!

Since its inception, Power BI has been a leading tool in self-service analytics. This week at Build, Microsoft released an exciting new feature available to preview – Power BI Datamarts! Power BI Datamarts enable self-service users to build and distribute an analytical solution from end-to-end. Data ingestion and preparation, data exploration and analysis, data modeling, and report design can all be done in a low- or no-code experience in Power BI Service!

Case I have one big Power BI dataset with multiple source tables and one of those source tables is refreshed once every hour and all the ot...

ABSTRACT 📝 At the end of last year , one called ExecuteQueries was added to the endpoint portfolio in the Power BI REST API . It is an endpoint that allows you to extract data directly from datasets . Although it also brings limitations, I think that its advantages outweigh them. So what

I show you how to create a Power BI report with a dashboard and a Power BI Alert when there are new additions to the known issues.

General availability announcement for Enhanced Refresh with the Power BI REST API. Perform fine-grain refresh operations for improved scalability.

In amongst all the announcements at Build recently, you may have heard about a new member of the Power Platform being launched: Power Pages. You can read the docs here, and there’s a good, de…

Power BI Architecture with separate layers: In a Power BI report development cycle, we can have separate layers since we can use many components to build report files which facilitates the re-usability of elements for better integration. we could have data preparation , data modeling and data visualization layers, such as:

Metric and goal setting is paramount when formulating business operations. That's why Microsoft Metrics (previously known as ‘Goals’) make it possible to keep every member of a team striving toward a singular, unified key objective and ensures a higher probability of positive outcomes. In fact, in this study regarding goal setting and optimism, it is shown that the goal setting process assists individual workers to improve their performance and enhances optimism for business success. So, how can productivity metrics and business objectives be met while also integrating the latest and greatest data analysis technology available? In this blog, we will be performing a deep dive into the world of productivity within Power BI’s Metrics and Scorecards.

Learn how to use Datamarts in Power BI. They enables you to store and explore your data in a relational and fully managed Azure SQL DB.

Preview data is now available!

I noticed Adam Saxton post a tip on the Guy in a Cube YouTube channel about publishing reports from Power BI Desktop for external users. According to Microsoft Docs (as of June 21, 2022), you can&#…

In this blog post I show users how to document all their Power BI Row Level Security Roles & store the output in SharePoint

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 …