Power BI

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

The tenant settings in the admin portal of the Power BI Service are incredibly important. The tenant settings include a wide-ranging number of things that significantly affect the user experience. It’s really important to manage the tenant settings effectively. In this post I’m going to talk about t

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...

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!

Guest Author: Henk-Jan van Well As a follow up to two older Matrix Multiplication posts here and here, I would like to share with you an alternative query for matrix multiplication using the Cartesian product-functionality within Power Query. This post was contributed by guest author Henk-Jan van Well.  When reading through Gil’s book I got […]

In many businesses, sales don't come in equally distributed over the year. Learn how to deal with Forecasting with seasonality in Power BI.

Do yo want to return an (empty) table instead of an error message? This function creates a table string from schema in Power Query.

This article analyzes the fields parameters feature in Power BI, unveiling some of the internals of its implementation. IMPORTANT: while this feature is in

Let report readers dynamically change the visuals in a report using field parameters.

This higher-effort engagement stage often requires you to explore new space, and it’s where you’ll need to stretch your skills and abilities.

In some scenarios i or the user would like to see how far the Cloud Flow Process (PowerAutomate) is already after I started it via PowerApps. Unfortunately it is not possible to use “Respond …

Imagine you bought a brand new, top of the line red Ferrari, but in place of a performance driver's seat, it came with a $10 folding lawn chair installed... 26 comments on LinkedIn

Dynamics 365 CE, and Model Driven Power Apps built on Dataverse can create views to be filtered to only show records where a username field on that record, such as 'owner' equals the current user. (e.

It's a terrible title, but by the end I hope it makes sense Today I had some spare time and I thought I would do some c# that is always good to keep your mind going.  The goal was to create a script that given a base measure, you can then specify a column and a new measure will be generated for e

¿Queres saber sobre los orígenes de datos que utiliza LaData para realizar sus informes? Power Bi Córdoba, Argentina.

Tabular Editor and nothing else

UPDATED WITH EXTRA REQUIRED STEPS The May 2022 release of Power BI brought an exciting feature that greatly enables self service BI. I’d highly recommend watching Wyn Hopkins: Field Parameter…

easily compare different categories on the same axes

Context transition is one of the most obscure topics for DAX newbies. In this article we introduce context transition, its effects, and how to leverage it r

Power BI just launched a new Known Issue page!

Hey Power BI administrators - Have you noticed there's a new tenant setting for user experience experiments? It allows the Power BI service to conduct ...

Lightning Forms and Lightning List Actions from Lightning Tools enables you to create buttons that will generate documents from SharePoint list items.

Blogging about Power BI, Power Platform and other things I find interesting.

Join us on May 19, 2022, to celebrate the one-year anniversary of Azure Static Web Apps! Come connect with others in the developer community and increase your Azure Static Web Apps skills in a fun, collaborative way. Hear from keynote speakers like Scott Hanselman and Donovan Brown, along with...

Create Power BI custom visuals with PBIVizEditBuild your Power BI custom visuals easily under 15 minutes with mouse clicks without any coding. Only pay for visuals when you are satisfied with the …

PureViz Infographic custom visual allows turning your creative ideas into super-fast & animated Power BI visuals. Start from Power Point and bring your data to life!