Power BI

In this PowerApps Tutorial, We will see what is LastSubmit() function in PowerApps, Why we will use this function, and how PowerApps LastSubmit() works on the PowerApps screen or app.Also, We will …

Export your Power BI desktop data into Excel with only one click. Then you can setup pivot tables, add theme & graphics, macros and do whatever you want.

Today we are happy to announce the general availability (GA) of Power Apps component framework for canvas apps. This release marks a significant milestone for Power Apps to bridge the gap between code-first and citizen developers and offer true no-cliffs extensibility.    

We are happy to announce that Office Scripts in Excel for the web is now generally available for all eligible users!   What is Office Scripts? Office Scripts is an automation feature-set in Excel for the web that allows users with all levels of programming experience to automate their repetitive wo...

If you follow my blog posts, you know already that I'm a huge fan of the integrations of Power BI with the Power Platform, specially Power Apps and Power Automate. I truly believe that these integrations can take your reporting solutions to the next level, and if you are not into these topics already, now is the time to learn a little bit more about it. In this blog post, I'm going to talk about the integration of Power BI + Power Automate. During the last few months, I really struggled to find

Last week I showed how the new MaxEvaluationWorkingSetInMB registry setting could increase the performance of memory-hungry Power Query queries in Power BI Desktop. In this post I’ll show how…

There was an interesting announcement today regarding Visio: In summary there will soon be a lightweight, web-based version of Visio available to anyone with a Microsoft 365 Business, Office 365 E1…

Power BI is making it simple to view and analyze your personal Microsoft Teams activity with a new preview feature to ‘Analyze your Teams data’.

Learn how to export the Power BI audit log with no limitation and any size. No scripting or coding is needed.

Learn what happens when you open a PBIX file with Power BI Desktop and why you might wait many seconds with large files. Do you need more RAM or a faster CP

We are excited to introduce the modern app designer, a new authoring experience now available in Preview worldwide. It is now easier and faster than ever to build model-driven apps. With just a few clicks, you can get robust, powerful grids and forms on top of Dataverse, and preview your app changes directly in the authoring experience.

We’re excited to introduce new developer samples for embedding Power BI analytics in Salesforce. You can embed Power BI report, dashboards and more in Salesforce for your organization or for your customers. By embedding Power BI in Salesforce, your users will have access to Power BI interactive data visualizations that can be connected to all … Continue reading “Embed Power BI in Salesforce”

Power Apps Containers make it easier to design the layout of an app. In this visual guide I will use examples to illlustrate how to use them.

When you want to implement 2 levels of grouping in Power Apps you will discover quite soon that you can't have more than 1 nested gallery. So how can we

Increase the performance of Power Query transformations in Power BI Desktop by setting the MaxEvaluationWorkingSetInMB registry key

Tabular Editor is a Power BI Tabular Modelling productivity tool developed by Daniel Otykier. I blogged about Version 2 of the Tabular Editor in this article here. The 3rd edition of Tabular Editor has just been released, and it is a major upgrade from version 2. TE 3 is not [...]Read More »

May 2021 bought many updates for Power BI. Link to the details on these updates can be found here. Out of all the updates, one of the updates 'Modern Visual tooltip' has been specifically a topic of interest and it seems to be the most awaited one among all the updates. Today in this blog we will ta...

Most of what I do in my day job involves listening. Specifically, I spend a lot of time listening to people who use Power BI[1] talk about why they use it, how they use it, and where they struggle …

SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. If you

As anyone who is familiar with my series on building a data culture knows, training is an absolutely vital success factor for a community of practice. This isn’t limited to developers, admini…

Learn how to get a field's value from another table in Power BI using the Related function in DAX and traversing through the existing relationship

In this post I will describe how to get previous row data that matches a criteria. This post will demo getting a person's previous score.

Looking to boost your Power BI development? Check how the latest version of Tabular Editor can help you become a true Power Bi hero!

Power Apps SharePoint Document Library Browser Step 1 Create Document Library. (You can use existing Documents library) Create a column of type

Hierarchy FilterFor Microsoft® Power BIThe Hierarchy Filter is a selector component like a native slicer, just that it can display multiple category values in an expandable tree view used to …

SUMMARIZE is a very powerful and very complex function to use. This article describes its internal behavior, and provides guidance on how to use it. If you like to follow best practices, you can just read this paragraph out of the entire article. If you are using SUMMARIZE to calculate new columns, s

Until now it was all too easy to create and publish a solution and overlook the backing relationships needed for the lookups that are present in the tables.  A new feature will help eliminate this issue. Before October, you will need to validate your existing solutions now to make sure you have included all required relationships for your lookups. 

Canvas app settings have been updated to a modern look, recategorized according to feedback, and streamlined to help you find and set what’s important.