Power BI

Sample Table In the following scenario, I would like to insert a sum row for each 5 days as an example.   Method 1      let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("bdBLCsAgDATQu7iWkon1dxbx/tdoAqWQjrh7yiTjWklFcdlJOUEk7fyRGtUgxaQHuU1GkGrSgjR60yl5+HgEmhRk9/8k+N4z...

When you are new to use the relative time filter and relative time slicer in a report, you might find that the filtered records are not consistent with that you observe the results manually. For example, I have some ticket data as below. I hope to see the records created in the last 12 hours of the ...

I created a video to demonstrate how you can highlight any time-bound events on a chart timeline using DAX and conditional formatting in Power BI.  In addition, in this example, we will analyze and visualize how events like Covid lockdown, promotions, and campaigns can impact sales performance. You ...

Today we are happy to announce public preview of default label policies in Power BI Desktop and call out significant features that address top asks for Power BI information protection released in the last few weeks.

Learn how to secure report pages or tabs in Power BI from unauthorized access and control who has access to what page.

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 … <p class="link-more"><a href="https://powerbi.microsoft.com/en-us/blog/new-premium-metrics-app-preview-now-available/" class="more-link">Continue reading<span class="screen-reader-text"> “New Premium Metrics App preview now available”</span></a></p>

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.

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 […]

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 …