Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
peter_baxter
New Member

Power BI Desktop error when connecting to local MySQL

I want to pull JIRA data into my version of PowerBI Desktop to create my own dashboards but can't seem to connect.

 

I know the web version of PowerBI has a content pack you can use, but you can't customize the reports with the web version of PowerBI - you need to be able to pull the JIRA data into the Desktop version of PowerBI to modify the reports.

 

Anyone have any insight, advice, thoughts, visions or premonitions on how to do this?

 

Thanks in advance.

 

Peter Baxter - Hamilton, Ontario, Canada

1 REPLY 1
v-sihou-msft
Employee
Employee

@peter_baxter

 

In Power BI Desktop, when connecting MySQL database, you need to install MySQL Connectors. As I tested, it can connect MySQL database properly.

 

1.PNG

 

2.PNG

 

3.PNG

Also if you already create a report on Power BI Service, you can download a .pbix to your local environment.

 

6.PNG

 

Regards,

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.