Power BI

Why you need to build a custom connector to use Power BI with REST APIs that use OAuth2 authentication

At this moment, there is no color picker in Power BI or Excel, but here is how to use eyedropper PowerPoint to detect RGB and Hex color codes.

Create a running total formula in DAX that starts from arbitrary dates instead of considering the complete history available.

ALLEXCEPT is a handy DAX function to retrieve all the columns of a table except for some. When used as a CALCULATE modifier, its behavior is less intuitive

This blog post shows how to integrate the Report Names into the Power BI Log Analytics report so that it shows more meaningful data.

A fortune 500 pharmaceutical company is using Power BI to revolutionize strategic planning. The company worked with Microsoft partner, Visual BI, to implement their ValQ capability. Read this customer story to learn more about the company’s solution.

Expanded availability of Power BI and Excel features to Power BI Free license users

Announcing new features for Power BI Goals, including automated status rules and improved filtering.

Goals in Power BI Mobile apps was Just released! Having Goals in your Power BI mobile app lets you monitor the health of your business directly from your smart phone, no matter where you are at.

On-premises data gateway (standard and personal mode) release for August 2021

We are excited to announce that the all new metrics app for premium capacities is available here as public preview! Please be sure to check the docs for detailed installation instructions. This app will be the standard and only metrics app available out of the box for premium capacities after Premium Gen2 reaches General Availability … Continue reading “New Premium Metrics App preview now available”

Case My company doesn't allow public end points on my Azure resources like the Azure SQL Database and the Azure Data Lake. Now Power BI can...

First look at two Power BI Goals updates: Filter the Goals by Status to see only the ones you want and set status automatically using rules!

Take a look at Power BI Goals functionality in Power BI Mobile! See how you can view Goals, Sub Goals, and perform Check-ins from your phone.

If you want to change the display units without a suffix, you cannot do it through formatting or formatstring, you need to use a calculation group.

We are proud to finally unveil Power Apps Web, the latest product developed by our team and their first one focused on Power Apps.

The last blog in the series of transforming a local into a global enterprise grade solution. After everything about sharing content and requesting access to content, and many other topics, it is ti…

Paginated Reports for Power BI offer pixel-perfect control over the format of each element of a report. This article will explain how to create a Paginated Report and how to configure the new Paginated Reports visual in Power BI Desktop.

[vc_row][vc_column width="1/1"][vc_single_image media="88228" media_width_percent="100"][vc_column_text]In this Power BI tutorial, I show you how to add a vertical text box to your […]

Hi all, It's been a while since I posted a component here... So here is a little one I made today and that I wish to share with you... A fully

This app includes custom function through enhanced component property. For given single character, it returns svg code of 16/7-segment display, so

Automatic aggregations are now in public preview! Unlock massive datasets without having to copy large volumes of data or manage data loads. Automatic aggregations are managed automatically by Power BI, accelerating time to insight, and reducing TCO.

Fowmy is the founder of ExcelFort Consulting and is a Microsoft Certified Solution Associate (MCSA). He is a qualified and well experienced Finance Professional with over 15 years of experience. …

• Sqlbi.PbiPushDataset: It is a library based on .NET Core 3.1, which is compatible with Azure Functions. This library can be used directly by your C# or .NET code in case you do not want to rely on …

As makers grow their solutions and go beyond no-code/low-code, there are key pieces of information that makers need to connect to the Power Platform through the SDK, service endpoints or developer tools… this information is now readily available on the maker portal.

Maintenance Window Management is a brand new capability for admins to configure App & DB update maintenance schedule at an environment level utilizing the Power Platform Admin Center.

When using a relational database as the data source for Power BI solutions, most report creators choose to take an easier path - import the data directly from tables, without even thinking or being aware of database views! In this article, we demystify views and explain why they should be your preferred choice when importing data from the SQL database.

This article introduces the Power BI User-defined Aggregations feature. It includes a walkthrough example (with video) showing how to configure and test a simple model to use this feature. If you have not used Power BI User-defined Aggregations before, need a refresher or reminder, or are just keen to understand how to configure, this article … Continue reading Intro to Power BI Aggregations

Today I am sharing another of those videos where I show you how I have built out my COVID report for Australia http://xbi.com.au/ca   The live report is running a few weeks ahead of my blog videos, so that is why you will see features in the live report that I [...]Read More »

Earlier this month I published a new and very practical Power BI app on Microsoft AppSource. The app audits Excel workbooks and detects changes and errors. To implement the app I needed to resolve key obstacles that are very common when you import Excel workbooks using Power Query. How do you import the data from […]