Learn the difference and what it takes to transition to Fabric successfully!

Unlocking the potential of Copilot

• Suggest content for a report
• Assisted Report Creation
• Prompt Data Insights
• DAX Formulation and Description

Hey there! Whether you're a seasoned pro or just dipping your toes into the world of data analytics, we all know there's a new player in town —Microsoft Fabric. Since the first Fabric Conference to the most recent updates, a lot of advanced capabilities have been introduced in the game. Let's take a moment to take a step back and brush up our Fabric basics, and ensure you are ready to revolutionize your data game.

Learn about all the Power BI features released in 2022.  

The new Datamarts feature that was just announced in Microsoft build has a very special bonus for all the Mac developers that always wanted to work on Power BI Desktop but couldn't let go of their Mac..

In this video, I will walk you through how to easilyhttps://youtu.be/XZOPriif6Pw  create a custom PAGE NAVIGATION PANEL in Power BI with Bookmarks & Buttons. You will also learn many visualization tips and tricks along the way.

Did you ever have to combine a few tables, but you were not sure if you should do that in SQL Server with UNION ALL, in Power Query with APPEND or in DAX with UNION?

In general, where are the differences? And how do the three approaches behave in case of duplicate rows, unequal number of columns, deviating column names and order?

In this article we will analyze in detail the different approaches.

The post is relatively detailed, for all of those who consider it too long (tl;dr) here is the comparison table:

OLE DB or ODBC error while connecting to Amazon Athena from Power BI Desktop using ODBC connector

Dataflow Import API – How to deal with special characters?

This is an interesting issue. The error message make us believe issue is with the M Query and the Web.Contents function or dynamic data sources, however the reason is pretty simple.

Unable to connect to IBM DB2 from PBI Desktop

Error:

• IBM DB2: ERROR [42704] [IBM][DB2]SQL1234 "SYSCAT.SCHEMATA: is an undefined name."

Power BI September 2020 Update

Thank you to the Power BI Community for contributing so much! We have a winner and an honorable mention.

Featured Data Story contribution winner for August:  #ProjectHealthViz August 2020 by community member Regiso  This report can be used by people who don't usually design reports, and its a great example of how to use the Chord Diagram visual, with clear color and contrast combinations .

Honorable mention is:   Visual Storytelling - An Environmental Risk Assessment by cborovac

We'll reach out to the winners directly!

For more options and fun for your Data Story creation, we’re introducing monthly themes.

The theme for September is “Accessibility”;

The theme for October is: “Power BI and Excel, better together”

Looking forward to seeing your awesome Power BI contributions on community.powerbi.com!

Kelly Kaye

Power BI MVP Lead, Power BI User Groups, Webinars, Community

Refresh failure on Power BI Service for Jira connected datasets

See which Data Story we really liked in June and July as well as the honorable mentions. Find out the themes we're looking for in upcoming months at the end of the blog.