WordCloud custom visual in Power BI gives a great way to visualize the most occurring words in the data. The size of the word depends on how frequently it appeared in the data-set. One can limit the number of words to be displayed in WordCloud. The defualt setting displays 200 words in this visual.
But, have we ever thought of modifying this word limit without changing the underlying word-limit setting in the visual. Basically creating a slicer in the report and then changing the number of words to be displayed in the WordCloud.
This article here gives a workaround on how one can achieve this functionality in Power BI.
Recently, I have noticed that there was a lot of content talking about gzip decompress with Power Query, but I haven't seen someone talking about decompressing .zip files. The truth is that gzip is a most common file extension for data with the Azure suite. We can handle gzip with Azure Data Lake and Azure Data Factory. Anyway, in this article we will check how to decompress a ZIP file to explore your files inside, like a Windows folder in Power Query, in a very similar way as the gzip is done. If you haven't seen how gzip works, you can check this post about it.
A few of our customers reached out to us for a Dynamics Navision connection from Power BI Desktop, and we successfully implemented a secure connection to NAV, following the process below, which I thought would be good to share with other users as well, who have a requirement to connect to the NAV server.
There is an interesting functionality inside the Power BI Service in which a user can create an alert about a required numeric rule within a visualization. This will give them an early notification about a business process or allow them to keep up to date about specific situations at the exact moment that they occur. In my opinion, the alerts are only comfortable if you have the mobile app, due to instant notification, like a text message, instead of getting an email. Emails are not always checked right away.
The issue here is that all these configurations are only for the user that configures it. However, what can we do when we want to notify other users about the alert created? Power BI won't let you configure another email or user to get this notification. For this reason, we are going to use Power Automate (formerly known as Flow)
If you want all your senior team looking at the same stock market information, creating a single report and pulling up-to-date information using APIs is a great way to achieve this. This blog gives you an end-to-end explanation of how to achieve this along with a Power BI Desktop file as an example.
In this article I review the difference between data types, data formats and data categories available in Power Query and Power BI. It's a long topic and this post brings an introduction to that topic.
"We want to be able to export an unlimited number of rows from Power BI from any filtered report, retaining aggregations and totals without the need for a developer to assist.". I was hoping to leverage Power BI Paginated reports which were released about a year ago. "Yes, we already considered that, but it's too complicated for our business users," the client stated
This article will show how to get a data result with three different languages in order to help people learn one knowing another one. The languages are Python with Pandas library, T-SQL and Power Query M. This is an original post from LaDataWeb.
Power BI Time Intelligence provides powerful functions to deal with Year, Quarter, and Month. But WTD and this Week vs Last Week do not have any out-of-the-box solution. Let’s quickly deal with Week Time Intelligence.