###### tags: `Dashboard`, `PowerBI`, `LLM`, `openAI`, `Copilot`

# Automatically create PowerBI dashboard with Microsoft Copilot

## Introduction: Revolutionizing Data-Driven Insights with Microsoft Copilot for Power BI

Embark on a data-driven journey like never before with Microsoft Copilot for Power BI! Imagine having a virtual assistant that understands your language and effortlessly transforms your ideas into stunning dashboards. With Copilot, you can just describe what you're envisioning, and voila – it creates visually appealing reports, fine-tunes calculations, weaves engaging narratives, and even engages in friendly data chats, all in a language that feels like a conversation. In this article, we'll explore the magic of Microsoft Copilot, uncovering how it empowers users to automatically whip up Power BI dashboards with the utmost simplicity and a touch of human-like interaction.

## Seamless Dashboard Creation: Turning Ideas into Reality

With Copilot and Power BI, we can simply describe a dashboard we want to build and create it in a second based on our own data. Let's take a look at how this works for a sales analyst in a hotel and resorts company seeking insights into customer profiles and factors influencing return visits.


Immediately, Copilot can create an interactive dashboard based on our own data. We can slice and adjust anything on the dashboard.


For example, let's switch to `Metrics and trends` to display our data in a different point of view. Automatically, Copilot updated the dashboard.


## Conversational Analytics: Engaging with Copilot Through Text

On top of that, we can also communicate with copilot by text like it is an assistane. Let's ask:

What are the main drivers for repeat customer visits?


Copilot added a new dashboard which uses Power BI's anaysis tool to explore key influencers for return customers in our data


Besides, we also gain the information of the most important feature from the chat .


To make the dashboard more accessible, users can instruct Copilot to add narrative summaries.

For example:

Replace the average days chart with a summary narrative for this page

Then, Copilot generated a summary session that highlights interesting insight in our data. This summary updates automatically whenever the underlying data changes.


## Customization: Tailoring Dashboards to Perfection
Just like that, a Power BI dashboard is generated within a second. Every element in this dashboard can be edited manually or through instructions with narrative text, providing users with unparalleled flexibility and control over their data visualizations.

Reference:
[Copilot in Power BI Demo](https://www.youtube.com/watch?v=wr__6tM5U6I)