cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Fowmy
Super User
Super User

Some common #DAX formula mistakes and solutions in #powerbi with the explanation.

Read more...

yingyinr
Community Support
Community Support

Power BI Premium VS Power BI Premium Per User

Read more...

V-lianl-msft
Community Support
Community Support

When exploring and analyzing data, we may need to add colored icons to help us visually identify patterns and trends. Currently, there are two main ways to add icons.  
1. Icon sets for conditional formatting 
a) built-in icon sets 
b) custom icon sets (json file of theme) 
2. Conditional fields 
a) SVG xml, Img URL, Built-in icon name 
b) Html-code of Unicode characters 

Read more...

selimovd
Super User
Super User

It was already announced since the end of 2020 that there would be an update in Power BI Premium capacities. After being in preview for some time, “Generation 2” or “Gen2” short, as the new version is called, is now generally available.

But what is the difference to the current Power BI Premium and what is going to change? Everything you need to know about Power BI Premium Generation 2 will be explained in this article.

Read more...

Kumail
Continued Contributor
Continued Contributor

Automatic aggregations will help unlock huge datasets for interactive analysis, enhance query performance, and enable interactive analysis over big data.

Read more...

TedPattison
Microsoft
Microsoft

Did you know that Power BI offers an Export API which can be used export Power BI reports into commonly used file formats including PDF, XLSX, CSV, XML, PPTX and PNG. The November session of Power BI Dev Camp session explains how to write the code to export both Power BI reports and paginated reports and explains the differences in supported output formats.

Read more...

s-richert
Microsoft
Microsoft

Take over existing goal connections in a scorecard with this PowerShell bulk update script

Read more...

skeets20
Resolver I
Resolver I

With the rollout of Aggregated Tables in PowerBI, we gained some much-anticipated functionality to improve performance large datasets.  The problem I’ve run into is that aggregation is very subjective and can still result in datasets that are still too large for publishing to PowerBI cloud. Additionally, it can take a frustrating amount of time for those aggregate tables to import into a developer’s local instance of PowerBI Desktop.  In this article, I’d like to show you how you can leverage PowerBI's Aggregation, functionality, Direct Query and a simple calculation group to partition an aggregated table by Current (import) and Archive (Direct Query) periods. This is one way to work with aggregated tables within the constraints of your licensed capacity and budget. There are definitely caveots to this approach that I will cover along the way.

Read more...

yingyinr
Community Support
Community Support

Use Power BI Rest API to export the Power BI Report in PDF format

Read more...

V-pazhen-msft
Community Support
Community Support

Scenario: Microsoft 365 usage analytics provides a dashboard in Power BI that offers insights into how users adopt and use Microsoft 365. We can find and use it in Power BI Service apps. But if you still want to get personalized or deeper insights, how will you connect the data model to create a report in Power BI Desktop?

Read more...

shreyachoudhury
Frequent Visitor

Write to the Power BI Report or Dashboard Data Source from the Power BI Report or Dashboard

Read more...

Fowmy
Super User
Super User

In this short article, I will share with you a simple technique to create a Dates or Calendar table template in Tabular Editor and add it to any Power BI file using a macro. 

Read more...

Greg_Deckler
Super User
Super User

Some consider EARLIER a relic of the bygone era when DAX did not support variables, criticize it's name and do not recommend using it but is EARLIER really that bad?

Read more...

smpa01
Super User
Super User

Combinatorics is one of the most important areas of data analysis. It helps in painting a meaningful picture from tons of data very quickly.

 

Read more...

yingyinr
Community Support
Community Support

For some Power BI users, it is quite simple to calculate the difference between two rows by using DAX. And this article will provide you with two solutions about how to implement that in Power Query.

Read more...

Helpful resources

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