How to get the data

[Anonymous]

Hi Everyone

           I have already 7 core data in that datasource. day to day coming 40000 data are coming. but am using that  mysql Datasource. so how to get that all data. if any possible please share to me

[lbendlin]

How wide are your rows (ie how many columns)?  Power BI can handle many millions of rows if you keep them narrow.  You can consider incremental refresh if you are concerned about the processing times (and if your data won't change after you receive it)

[Anonymous]

Hi 

    But my client want to 2018 to still now data. 30 columns and 7 core data is there and day to day adding 40000 rows. so in this suition what can i do. ssas is working for this type of requirement ?.but my data source is mysql.

[v-shex-msft]

Hi @Anonymous,

Did these stored records change normally? If not, you can consider splitting your database records into two parts and create two query tables to mapping these records.
One of these stored the cold data which means not often changes, you can use import mode to design this query table and not setting scheduler refresh. (you only need to manually refresh them occasionally or setting a weekly level low-frequency refresh) The other one stored the recent data and you need to set the daily refresh.
After these, you can create a merge table to combine these two table records. It should get better performance because you only refresh some of the records.

BTW, incremental refresh show also suitable for your scenario, you can turn on the option to detect and refire change data, it should help to reduce the refresh amount of records.

Incremental refresh in Power BI 

Regards,

Xiaoxin Sheng

[Anonymous]

Hi Everyone

             am try that way but this is not suitable on that. so am choosing to ssas connection. Am having 7 core data in datasource. then day to day adding 40000 rows. so i could not import the data. my data source is mysql.mysql is only available for import connection. once import on that data it occupy more memory in that power bi. am choosing to ssas connection. but how to connect mysql to ssas.

[v-shex-msft]

Hi @Anonymous,

Do you mind using ODBC driver to get data from MySQL? It seems like ODBC direct can be work wiht the direct query connection mode.

DirectQuery DataDirect ODBC drivers in Power BI 

MySQL Connector/ODBC Developer Guide - MySQL 

Regards,

Xiaoxin Sheng

[Anonymous]

HI 
 Am trying to this datadirect odbc driver. but am getting this type of error. so how to solved it ?.

[v-shex-msft]

Hi @Anonymous,

I think you need to check the hostname and port number to confirm if they configued correctly. BTW, please also check the corresponding firewall port and policy setting if they blocked the request.

Regards,

Xiaoxin Sheng