cancel
Showing results for 
Search instead for 
Did you mean: 

Find articles, guides, information and community news

Most Recent
Super User
Super User

So, recursion is impossible in DAX, just like "for" and "while" loops are impossible in DAX...

Read more...

Super User
Super User

Everyone knows that DAX does not support traditional for and while looping. But what if it did?

Read more...

Super User
Super User

Resurrecting my old series, "Fun with Graphing in Power BI", this time with ray tracing!

Read more...

Super User
Super User

This article is designed to go with my recent Data Stories Gallery submission, 3 Year Analysis of Gartner Magic Quadrant Leaders for Analytics and Business Intelligence. It's a rather lengthy title I know! Luckily however, the analysis was rather quick and easy. But, I thought that a few more insights could be shared around this than simply what appears in the Data Story Gallery posting or within the Power BI report.

Read more...

Administrator jfeil
Administrator

We will create a custom connector in Flow that refreshes any dataset in PowerBI you want and you can use it with any other connector.  Bonus, we can use it for calling other PowerBI API actions as well.

Read more...

Super User
Super User

The web query feature "Web by Example" is one of the top 5 new features of 2018. This article demonstrates how to make this powerful feature even more powerful by turning the queries created by this technique into M functions, enabling you to quickly and easily build custom functions that can collect data via the web for sites that have data spread across similar individual pages.

Read more...

ruthpozuelo
Advisor

You have millions of rows of data stored in your data warehouse, you have it accessible and available for business users and report users, but how do you effectively tell a story using all that data? How do you unlock the secrets and the potential your data has?

 

Check this blog post to get a summary of the webinar I did with Charles Sterling on the Power BI YouTube channel where you will learn tips & tricks on how to effectively visualize your data, the do’s and don’ts and how to present your data so questions can be asked and get answered in the same report.

Read more...

karaoan
Advisor

Power BI offers fantastic ways to integrate data from online sources. Often it is useful to just use parts of that and extend your own data set with details from an online API.

Read more...

Super User
Super User

In this blog post I show how to connect to a Read-Only replica for SQL Server Import queries, which will mean the operational systems are unaffected by queries.

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

I wanted to run through some fantastic visualization techniques that you can incorporate into your Power BI models and reports.  The first one is what I call Multi-Threaded dynamic visuals and the second one is Multi-Measure dynamic visuals.

 

Picture1.png

 

 

 

 

 

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

Today, I wanted to cover in detail some fantastic scenario analysis techniques you can use inside of Power BI. Power BI is an amazing tool if you want to predict what may happen in the future or alternatively see what could have happened in the past based on certain variables changing in your data.

 

community.png

 

 

 

Read more...

Kumail Regular Visitor
Regular Visitor

Are you working on big data and want to leverage the powerful capabilities of Power BI desktop? Then Incremental Refresh is a key feature to learn. It makes data refreshes faster and more reliable with less resource consumption.

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

With today's post I wanted to run through some examples of how you can solve errors in your totals within Power BI. Via the Enterprise DNA Support Forum, I get to see a lot of issues and requests that users who are working in Power BI Desktop have.

 

community 1026.png

 

 

 

Read more...

Administrator await
Administrator
EnterpriseDNA Regular Visitor
Regular Visitor

If you are creating some analysis inside of Power BI and you’re utilizing DAX measures, then having a superior understanding of how ITERATING functions work is very important. This is what this particular post will showcase to you - understanding how important these functions are.

 

community blog.png

 

 

 

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

In today's post, I wanted to cover a few examples of how you can incorporate financial years into your Power BI models and reports. Sometimes, your date tables won’t have the custom financial years that you require for your analysis. Not only could it be financial years but you might also need to bring into filters your financial quarters.

 

community blog.png

 

 

 

 

Read more...

TedPattison
Advisor

In Part 2 of this blog series, I will discuss the purpose of dedicated capcities and explain the differences between Power BI Premium and Power BI Embedded. I will also provide the neccessary details so you can choose the right type of dedicated capacity for a particular scenario.

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

In this post I wanted to go into a few financial reporting tips you can utilize inside Power BI. Many of you who have been using Power BI since it was re-released a few years ago know that financial reporting inside of the tables we were given has been relatively difficult.

 

community blog.png

 

 

 

 

Read more...

TedPattison
Advisor

Power BI provides developers with Platform-as-a-Service (PaaS) capabilities which make it possible to embed Power BI resources into custom applications. By learning to use a set of APIs created by the Power BI team at Microsoft, a developer can embed Power BI reports, dashboards and dashboard tiles into custom web applications that target the browsers, tablets and mobile devices.

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

Today, I want to talk about cumulative totals. I want to do a deep dive into a few ways that you can create these inside of Power BI. In this first tutorial, I want to show you the most common pattern which you can utilize to create cumulative totals in a dynamic way.

 

community blog.png

 

 

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

In this post, I want to dive into some of my best practices for Power BI Desktop development. I think bringing all these ideas together will give you a very good understanding of how I like to approach all Power BI reporting and analysis that I complete myself.

 

community blog.png

 

 

 

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

Today, I want to touch on a really fascinating topic inside of Power BI. I call this one virtual tables. If you can start understanding how to incorporate virtual tables inside your DAX functions, you will quickly see the opportunities to extend your analysis even further.

 

p8.png

 

 

 

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

Today I wanted to cover what I call SWITCH True logic. If you haven't used the SWITCH function yet, you certainly should be. It's a far superior way to write complex logic which is traditionally done with nested IF statements if you come from an Excel background.

 

0907.png

 

 

 

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

In this post, I want to dive into how you can run analysis in Power BI with a non-standard calendar. This is quite a common occurrence out there because not everyone works on the standard calendar and standard months, weeks, quarters, etc.

 

p7.png

 

 

 

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

In this detailed post, I wanted to focus on time patterns. I will show you four different examples of ways you can utilize time intelligence functions effectively inside Power BI. Hopefully, by going through these examples you'll see the versatility of this great grouping of DAX functions available to us inside Power BI.

 

P5 Community.png

 

Read more...

karaoan
Advisor

In this blog we cover how to realize asymmetric reporting requirements dynamically in a Power BI Matrix or Pivot Table. This is a typical requirements in financial forecasting and reporting.

Read more...

karaoan
Advisor

As I see lots of ongoing questions and misinformed comments (“Power BI can’t be used for financial statements”). Here I will cover a simple approach how you can realize financial statements with dynamically calculated subtotals like profit and loss (P/L), balance sheet, cash flow etc.

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

Today, I want to run through a few different budgeting techniques and examples that you can use in Power BI. Running budgeting analysis in Power BI can sometimes become complex and difficult. The biggest reason is that a lot of times you're dealing with data at different granularities.

 

p5 blog.png

Read more...

Super User
Super User

Merging tables with the same granularity in the query editor will return the same than a VLOOKUP in Excel. Do you know how to achieve this if there are multiple rows per key in the lookup table (and you just want to return the first ... or the last)?

Read more...

EnterpriseDNA Regular Visitor
Regular Visitor

Have you ever heard of the Pareto rule? It is the theory that says 20% of your customers or products will deliver 80% of your profits. I have created a short tutorial around the formula and visualization techniques you can use to effectively showcase this analysis inside of Power BI.

 

P4 BI Community.png

 

 

Read more...

Helpful resources

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