Power BI

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.

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 …

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.

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

A fun way to use Power BI.   For the folks who play Fantasy Football, here is a Draft Kit to help pick the best players for your team.  By entering in your league's custom scoring rules, this report will apply those rules to the stat projections from NFL.com, and create a customized view of how the ...

[vc_row][vc_column width="1/1"][vc_single_image media="88222" media_width_percent="100"][vc_column_text]In this Power BI tutorial, I show you how to build a quadrant chart for quadrant analysis […]

You may have noticed that a new dataflows connector was announced in the August 2021 release of Power BI Desktop, and that it now supports query folding between a dataset and a dataflow – whi…

This is not the first time I have shared this concept. In my previous article I showed how it is possible to add a prefix to every column in a table. This article today is slightly different. Today I am removing text from multiple columns all at once using some [...]

It is often the case in Power BI you need to filter your data to include or exclude rows where there are blanks. Be careful though, because you might get unexpected results. Consider this table: