Time for the second of seven blogs, as part of my blog series regarding Storytelling with Power BI. During this blog series, I will elaborate on seven topic which can be used to apply storytelling …
<p>There are several key improvements releasing this week. First, there are a number of new SharePoint connector actions, including working with Doc Sets, permissions, and creating Folders. Seco…
As another section of the Power BI online book: from Rookie to Rockstar, I would like to get start working with Power Query. From my point of view learning through an example is the best way to learn …
Get Images from Web Page Into the Power BI Report Using Power Query
Power Query can connect to a web page and get data from there, and I have explained it before in my article about movies data analysis. However, the default way of getting data from the web page doesn…
Check Out the Updated Violin Plot Power BI Custom Visual
I wrote about the violin plot custom visual by Daniel Marsh-Patrick back in February. I thought it was a good visual then, but version 1.3 has recently been released with some nice enhancements. First…
Find overlapping time periods using #PowerQuery - Part 3 (Fast & Furious)
In the last post here, we walked through the steps to detect overlapping time periods and calculate their durations. We used Cartesian Product to match all the pairs of tasks of the same resource, and even used the M function Table.Buffer to accelerate the load of the table. In this article, we will learn how …
Object Detection Application with AI Builder and Power Apps
In the last posts, I have explained how we able to set up the AI Builder for Power Apps and Microsoft Flow. Also how we able to do classification in Power Apps has been explained. Now in this post, I am planning to show how to create an Object detection app using AI builder in…
Adding More Aggregate Columns To The Output Of Table.Profile
A few years ago I blogged about the Table.Profile M function and how you could use it to create a table of descriptive statistics for your data: https://blog.crossjoin.co.uk/2016/01/12/descriptive-sta…
To tidy up your Power BI solution, there are some options, and one of them is hiding fields from the report view. This option, although simple, has a significant impact on making your Power BI solutio…
Activate AI Builder In Power Apps and Microsoft Flow
As I mentioned in Post 1 and Post 2, AI builder is a game-changer in Power Apps and Flow, it provides the facility to easy embed AI in applications and process without writing any code. Also, there is…
Find the Best, Worst, and Middle Values Using Simple Clustering with Power BI Scatter Chart
Machine Learning and AI can be advanced areas, however, there are some easy to use methods for that especially in the Power Platform and Power BI. Leila has written tons of blog articles about AI in P…
Find Error DAX Expressions, Export Tables, Gateway and APP Documentation all in Power BI Helper July…
What if you can find all details about DAX measures, and find all of the expressions that have an error in their syntax? Power BI Helper July 2019 version can do that for you. But not just that, it ca…
Some Simple Ways to Debug Your DAX Measure Code in Power BI: Debugging Virtual Tables
Debugging DAX codes can be sometimes a bit of challenge, especially because measures are dynamic in their nature, and you won't see their values in the data tab of Power BI, you will see their value w…
Aggregations for petabyte-scale BI is generally available!
The volume of data is growing at an ever-increasing rate. As it grows, so does the value to the companies that are able to unlock insights from it. Power BI is all about helping organizations…
Microsoft a Leader in The Forrester Wave™: Enterprise BI Platforms
We are thrilled to announce that Forrester has recognized Microsoft as a leader in The Forrester Wave™: Enterprise BI Platforms (Vendor-Managed), Q3 2019 tied for the highest score in strateg…
Power BI introduces service availability notifications
Having insight into the availability of your mission critical business applications is extremely important to ensure that you, as a Power BI admin, can serve your users. Today, we are pleased…
Power BI updates, performance and more... (July 22, 2019) | Guy in a Cube
Thanks for watching this week’s Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup145 Tech video: https://guyinacu.be/nocoderestapi Sources My Power BI Report is Slow – What Should…
Power BI Incremental Refresh – Understanding Detect Data Changes
Patrick breaks down how detect data changes works with Power BI Incremental Refresh. He demystifies some common misunderstandings when using this setting in Power BI Premium. Incremental refresh docum…
Video by: Reid Havens Learn about native and custom KPI icons feature now included in Power BI Desktop. See how SVG , image , and GIFs can all be used to create KPI indicators. Articles: PowerBI.tips …
The book, 'Accelerate', summarizes research from the State of DevOps Report and we've been using its four key metrics approach to improve our software.
Power BI licensing options are a mystery to many. It’s not that it is complicated; in fact, on the contrary, Power BI pricing is actually quite simple once you understand the basics. It is ju…
In this post I will look at filtering one slicer based a selection in another slicer. June 2019 Power BI Update included an update to allow a slicer to be filtered based on a measure, which means that you no longer need to use bi-directional relationships.
I’ll admit that I’m a bit less excited about Excel dynamic arrays than I was when I last blogged about them. Don’t get me wrong: from a pure Excel point-of-view they are still very cool, but I’ve s…
Power BI: Gateway Monitoring & Administrating- Part 2
Introduction This article is actually the continuation of my previous article where we saw how to call Power BI API's with in Power BI itself with some Powershell scripts, new API , M-queries and Automation. This is the second part where I'll explain how to create a report out of it and configure ga...
Power BI: Gateway Monitoring & Administrating- Part 1
Introduction As a PowerBI administrator it's always difficult to monitor the on-premises gateways with-in our organization,specically when the number on gateways has been growing rapidly.Today I'm going to tell you how tell how you can effecitivley administrate and monitoring those gateway in PowerB...