Avatar of Goutham
GouthamFlag for India

asked on 

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

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.
Power BIDatabasesMySQL Server

Avatar of undefined
Last Comment
David Johnson, CD
Avatar of David Johnson, CD
David Johnson, CD
Flag of Canada image

Blurred text
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Goutham
Flag of India image


thanks for for the inputs, connecting to mysql database I am clear I am able to establish the connection, I am looking the detailed list of technical inputs that mysql database administrator to be shared with Power BI developer, is it tables and column names please suggest the detailed list. 
What are your aims to get from PowerBI ?  You need to allow communication between the two.

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews


IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo