Forum Discussion

rangineniaditya's avatar
rangineniaditya
Frequent Visitor
8 years ago
Solved

Power BI with MySQL database

We have a transactional data and that is stored in MySQL database and data is adding on daily basis, we are analysing & visualizing the data with the help of PowerBI desktop. Now, the situation is l...
  • v-frfei-msft's avatar
    v-frfei-msft
    8 years ago

    Hi rangineniaditya,

     

    You cannot import the huge data as there are too many rows in your data source. Please check my answer as below.

     

    Q1 : Actually that depends, as dataset will be compressed in a reasonable level when you import the data into Power BI. Users with a Power BI Pro license can create app workspaces, with a maximum 10 GB data storage each, all the contents are included  like reports, dashboards. What’s more, the limitation on the dataset size of a PBIX file is 1 GB for Pro.

     

    Q2: Also that depends, as dataset will be compressed in a reasonable level when you import the data into Power BI . With Power BI Premium, you can get 100 TB of storage for each capacity you provision, all the contents are included  like reports, dashboards. What’s more You will be able to build models as large as the Power BI Premium dedicated capacity memory can hold. This means that the Power BI Premium P3 SKU will be able to support a dataset with 50 GB of data or more, and upcoming SKUs will offer capacity sizes that allow datasets with hundreds of gigabytes of data!

     

    Q3: It refers to the total size of all the datasets, reports and dashboards in it.

     

    Q4: Based on my research, there is no DirectQuery option for us to connect to MySQL currently. Maybe you can transfer your data to another database that direct query could be used, you can refer to the data sources that supported by directly here. Or you can select some necessary columns/ rows to import in the Advanced options like this.

     

     

    By the way, There is an idea about that, you can vote it up.

     

    Regards,

    Frank

v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

Hi rangineniaditya,

 

You cannot import the huge data as there are too many rows in your data source. Please check my answer as below.

 

Q1 : Actually that depends, as dataset will be compressed in a reasonable level when you import the data into Power BI. Users with a Power BI Pro license can create app workspaces, with a maximum 10 GB data storage each, all the contents are included  like reports, dashboards. What’s more, the limitation on the dataset size of a PBIX file is 1 GB for Pro.

 

Q2: Also that depends, as dataset will be compressed in a reasonable level when you import the data into Power BI . With Power BI Premium, you can get 100 TB of storage for each capacity you provision, all the contents are included  like reports, dashboards. What’s more You will be able to build models as large as the Power BI Premium dedicated capacity memory can hold. This means that the Power BI Premium P3 SKU will be able to support a dataset with 50 GB of data or more, and upcoming SKUs will offer capacity sizes that allow datasets with hundreds of gigabytes of data!

 

Q3: It refers to the total size of all the datasets, reports and dashboards in it.

 

Q4: Based on my research, there is no DirectQuery option for us to connect to MySQL currently. Maybe you can transfer your data to another database that direct query could be used, you can refer to the data sources that supported by directly here. Or you can select some necessary columns/ rows to import in the Advanced options like this.

 

 

By the way, There is an idea about that, you can vote it up.

 

Regards,

Frank

  • RIDWIV's avatar
    RIDWIV
    Helper I
    3 years ago

    so how one will load the data .... any other idea