We help IT Professionals succeed at work.
Get Started

what are those technical details from mysql database to be provided to Power BI

D_wathi asked
Last Modified: 2020-05-22
Dear Experts
We are having web application which is developed using apache,  php and mysql for database.  To develop reporting and analysis we have decided to use Power BI tool and hire Power BI developer and install Power BI desktop  to collect/process/deliver reports and analysis on local network, power BI desktop connects directly to the applications Mysql databasever.
Please help me understand what details the power BI developer requires other than reporting requirements and reporting logic. please help me the following
what are the technical details from mysql database side to be provided to the Power Bi developer ( in our case power BI  desktop directly connects to MySql database) little I know is to provide the  database name, table names and some talk about columns names I am not clear on this can you please help me to understand (what exactly column name mappings is ) i want to ask the complete requirement to the mysql database administrator please help on this.
Watch Question
The More I know, the more I don't know
Distinguished Expert 2020
This problem has been solved!
Unlock 1 Answer and 3 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE