cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Memorable Member
Memorable Member

Customers ask you to show total values in a bar-chart for all years along with each year individually.

 

FarhanAhmed_0-1601358870005.png

Read more...

Super User II
Super User II

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.

Read more...

Microsoft
Microsoft

Unable to open PBI Service on Edge

Read more...

Super User I
Super User I

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.

Read more...

Microsoft
Microsoft

Thursday, August 27th - Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5. In this session, campers will learn best practices for acquiring and caching access tokens in cloud-based development and learn a structured approach for implementing Power BI embedding. Campers will also learn how to integrate Node.js and webpack support into a .NET Core web application project to achieve strongly-typed programming when writing client-side TypeScript code against the Power BI JavaScript API.https://aka.ms/PBIWebinar082720 

Read more...

Super User IV
Super User IV

Continuous streak is needed when you have a set of start and end date with 1-day gap and they need to be combined.

Read more...

Microsoft
Microsoft

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.

Read more...

Super User IV
Super User IV

When it comes to deal with DirectQuery, most of us think that columns are not allowed. But this is not true. We can create columns. Let us explore more.

Read more...

Helper II
Helper II

Extracting data from the websites could be easy but equally tricky. In this article, I explain how we can get data from multiple webpages in one go, using Power BI parameters.

Read more...

Super User I
Super User I

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)

Original post from La DataWeb.

Read more...

Advocate I
Advocate I

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.

 

 

 

Read more...

Resolver II
Resolver II

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.

Read more...

Regular Visitor

"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

Read more...

Super User I
Super User I

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.

Read more...

Super User IV
Super User IV

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.

Read more...

Helpful resources

Join Blog
Interested in blogging for the community? Let us know.