Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to get the data

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

Need Help
Show and Tell

7 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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