Welcome to the Power BI Community Blog!

On this blog you will find articles, guides and information created by our community members and, from time to time, roundups and community news.

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

Read more...

Attachment

Get ready to flex your business applications skills – and pick up some new ones – at Microsoft Business Applications Summit.

Read more...

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...

If ALL your Power BI Dataflows refreshes are failing, the details explain below what might be the possible cause.

Read more...

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...

Turning "Web by Example" into Power Query Functions

by Super User ‎02-09-2019 09:03 PM - edited ‎02-09-2019 09:10 PM

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...

Attachment

Tour of the new Power BI Premium Capacity Metrics App

by Administrator jfeil ‎02-07-2019 12:45 PM - edited ‎02-12-2019 11:54 AM

Charles Sterling is back, this time with Swati Gupta!  Join them for their webinar on the new Power BI Premium Capacity Metrics App on Thursday, March 7th at 12pm PST.

Read more...

Hey Everyone, join Charles Sterling and Yana Berkovich for their webinar on Personal Bookmarks in the Power BI Service on Thursday, February 7th at 9am PST.

Read more...

DeNisha Malone’s talk at the Seattle Power BI World Tour was entitled “Telling a Story with Data”: A fitting subject for her, near to her heart. She could even tell the story of her own life with data.

Read more...

User Group Focus for the Power platform | March 13-14, 2019 in Houston, TX

by Administrator jfeil ‎01-30-2019 03:41 PM - edited ‎01-30-2019 03:50 PM

This immersive event offers 90-minute, multi-level sessions on Power BI, PowerApps, and Microsoft Flow. All sessions are deep-dives, presented by technical and functional experts, MVPs, and Microsoft team members.

Read more...

Show Tops & Others in a Table Visual

by Super User on ‎01-28-2019 07:18 PM

In this article i'll show you one way to show TOPs & others in a table visual.

Read more...

Storytelling with data and Power BI

by ruthpozuelo ‎01-25-2019 03:46 AM - edited ‎01-25-2019 03:49 AM

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...

February 14th, we will be recognizing the “Super Users for 2019!”

Read more...

Connect with experts, collaborate with your community and maximize learning opportunities at Microsoft Business Applications Summit. Back for its second year, this is the premier place for power users, analysts and technical architects to get hands-on with the tools you use every day – and get a sneak peek at what’s new and next. Registration is open – don't miss it!

Read more...

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...

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...

Amazing Dynamic Visual Techniques For Power BI - Detailed Examples To Review

by EnterpriseDNA Regular Visitor ‎11-13-2018 04:28 PM - edited ‎11-13-2018 05:24 PM

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...

Scenario Analysis (What Ifs) Tips & Techniques For Power BI

by EnterpriseDNA Regular Visitor on ‎11-04-2018 04:18 PM - last edited on ‎11-08-2018 02:01 PM by Administrator await

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...

Important Considerations for Setting up Incremental Refresh on Power BI Desktop

by Kumail Regular Visitor on ‎10-27-2018 01:28 AM - last edited on ‎11-13-2018 04:48 PM by Administrator await

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...

Fixing Total Errors In Power BI - I Know It Can Be Frustrating

by EnterpriseDNA Regular Visitor ‎10-25-2018 07:25 PM - edited ‎10-25-2018 07:41 PM

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...

The Power BI Community is Making Changes: More Details!

by Administrator await ‎10-24-2018 06:35 PM - edited ‎01-18-2019 03:07 PM

Need help logging in to the Community? We've got you covered!

Read more...

Find a Power BI Event near you

by Super User on ‎10-19-2018 02:22 PM - last edited on ‎10-23-2018 09:09 AM by Administrator await

Want to find a Power BI event in your local community?  Or maybe you are travelling and want to see what events may be happening while you are at your destination?  We have the solution for you.

Read more...

Iterating Functions - SUMX & AVERAGEX, Why You Need To Understand These Well

by EnterpriseDNA Regular Visitor ‎10-18-2018 04:49 PM - edited ‎10-18-2018 05:43 PM

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...

Working With Financial Years In Power BI

by EnterpriseDNA Regular Visitor ‎10-11-2018 07:19 AM - edited ‎10-11-2018 07:23 AM

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...

Core chart types and how to best use them

by MirandaLi Frequent Visitor ‎10-10-2018 04:46 PM - edited ‎10-10-2018 04:50 PM

If you are an adventurous kind, you might discover a vast array of fancy chart types beyond the regulars you see or use every day: Sankey chart, spider chart (radar), waffle chart, candle stick chart, stream graph, sunburst, word cloud, stacked bubbles, and you name it. At some point, you might start to question: do I really need to know every visualization display ever created to be an effective analyst? My advice is: master core chart types first before getting fancy! It’s like storing house-fixing tools in your garage.

Read more...

Developing with Power BI Embedding (Part 2)

by TedPattison on ‎10-08-2018 05:42 AM - last edited on ‎10-09-2018 06:25 AM by Administrator await

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...

Financial Reporting Tips For Power BI

by EnterpriseDNA Regular Visitor on ‎10-04-2018 04:55 AM - last edited on ‎10-08-2018 06:33 AM by Administrator await

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...

Developing with Power BI Embedding (Part 1)

by TedPattison on ‎09-30-2018 07:44 PM - last edited on ‎10-01-2018 02:37 PM by Administrator await

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...

Cumulative Totals In-Depth - The Many Variations In Power BI

by EnterpriseDNA Regular Visitor ‎09-27-2018 04:49 PM - edited ‎09-27-2018 04:57 PM

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...

October 2018 Update for Power BI Embedding Webinar with Ted Pattison

by Administrator await ‎09-26-2018 05:54 PM - edited ‎09-26-2018 05:54 PM

Join Ted Pattison and Charles Sterling as they discuss the latest updates to the Power BI embedding features offered through the Power BI Service. 

Read more...

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