Power BI

A very common requirement for a Power BI report that I stumble across at almost all of my customers is to automatically show data for the current day/month/year when a report is opened. At first sight this seems like a very trivial problem but once you dig into the problem, you will realize that all…

In the last two posts, I have explained how to access Azure Map and create bubble charts and Bar charts with other available settings. check the first Post from here and the second one from here. In this blog, I am going to talk about different layers we can have on top of the map. Read more about Azure Map in Power BI with Layers: Part Three[…]

In the last post, an introduction to Azure Map was presented. Azure Map has considerations and limitations as below( that may resolve later as now is in preview) You can use it in Power BI Desktop, Power BI Service, and mobile application But, not available Power BI publish to the web, Embedded and service embedding. Read more about Azure Map in Power BI: Part Two[…]

Learn about using Azure map for visualization in a Power BI report and options available for this geolocation service.

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.