Power BI

Hi & Welcome back to 24Days of PowerPlatform! If your job includes building business applications, it is highly possible that you’ve re-implemented some sort of data models or entities in a nea…

Working in Power BI with layered objects can block or cover a visual. This is undesirable from a user Perspective hit this link to read how to resolve.

Have you wondered how to find the native query in Power BI Desktop after query folding does its thing? Do you even know what query folding is? In this video, Adam looks at how you can find the query t…

A while ago I came across this interesting time intelligence solution that doesn’t use DAX measures to do time intelligence but rather solves it through the model. The pattern was...

2 tips for visualizations in Power BI Dashboard. In Power BI service (PBIS) there are reports. But there are also dashboards. Dashboards are sites to pin key visuals. (1) Pin layered visuals to the da…

Power BI has a robust set of functions to write date-based calculations. One of the areas that has proven to be a challenge is related to doing math on working days instead of normal dates. \ Here …

I’m quite excited to announce the new Power BI skills assessment on Pluralsight is in beta. This assessment is the result of me spending dozens of hours writing questions and some wonderful peer revie…

As it currently stands when I setup a dataset refresh it only emails me when it fails. I was recently at a customer where there is a team of Power BI Developers, and I wanted to find a way that all…

This article describes how DAX automatically converts data types in arithmetic operations. These small details can cause and explain differences in results

The new options from the CDS and PowerApps canvas applications is to use relationships with 1 to many, or many to 1, however this is natively in the Dynamics 365 CE and now on CDS, but how we use these type of fields; for a technical CRM developer this was using the Code Value for the Optionsets and using the ID Guid for the Lookups, among other parts for the complex object. The new web API help to resolve or make it more interesting the way we use these 2 objects, let me get into the details on CRM before we get into the PowerApps Canvas App.

Let's say you're a senior BI developer responsible for several Analysis Services Tabular instances (Dev, Test, Prod), each of which may host multiple databases. Each database, moreover, may have multi…

I had a question from one of my online Power BI Training students just this week who was struggling to import data from a large *.xlsb Excel file. I suggested she save the file as an XLSX file and…

An aggregated table can be a layer on top of the source DirectQuery table. This table needs to have a proper relationship set up with other tables, and also the proper storage mode configuration. Stor…

Fun with DAX – A-Maze-ing DAX (@PhilSeamark) 24 Days of PowerPlatform – Day 1 – Let’s kick it off.. (@wstrasser) Power BI Fast and Furious with Aggregations (@Rad_Reza) Power BI Dataflows and Slow Dat…

You did know that Power BI supports natural language queries, right? All you need to do is to add the Q&A button to your report and your customers will be able to navigate their data just by asking qu…

a couple of days ago, one of my friend challenged a group of "flowers" to come up with a Flow that converts a CSV file to whatever you want, in this specific case to JSON objects that can easily be tr…

As members of the PowerApps Customer & Partner Success team, we often get asked for resources to aid our customers on their PowerApps journey. Below is a set of links we've curated to help novice,…

Last week, I participated in an “Ask Me Anything” session where I answered questions around both Paginated Reports in Power BI, as well as questions around SQL Server Reporting Services and Power B…

This weeks webinar will highlight a community tool called Power BI Helper that helps you explore, tune and document your Power BI reports by Reza Rad.

Hi & Welcome back to 24Days of PowerPlatform! Today, I would like to introduce you to PowerApps. PowerApps allow you to quickly build business applications using various sources of data. Maybe …

Hi & Welcome back to 24Days of PowerPlatform! As I mentioned in the first #24DaysPowerPlatform post, the Power Platform combines the power of Power BI, PowerApps, Microsoft Flow and the Common …

I didn’t plan on writing a sequel to my Positioning Power BI Dataflows post, but a few comments I’ve seen recently have made me think that one might be useful. I also didn’t plan …

A Power BI administrator is a role for managing various aspects of the Power BI Service. This role can be assigned in Office 365. Anyone with Office 365 global admin privileges is also a Power BI administrator by default. Based on the tests I've been doing, I've observed that users with membership

Power BI offers fantastic ways to integrate data from online sources. Often it is useful to just use parts of that and extend your own data set with details from an online API. Here -as promised in ou…

In Microsoft Flow it is possible to use the Excel connectors to read data form a spreadsheet. there are however a few major issues with doing this: You data needs to exist within Excel Tables. Large t…

Over the last few weeks I have seen quite a few people asking questions about comparing two lists, synchronising lists and importing data into SharePoint lists. Within this post I'm going to include a…

Every year, in return for publicising the BI Survey (the largest survey of BI tool customers and vendors in the world) here on my blog, I get a free copy of the results and the chance to blog about so…