Power BI with MySQL database

[rangineniaditya]

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 like we have 500 GB data and Power BI is unable to import the data and it is showing error.

1. How much data power bi pro can handle?

2. How much data power bi premium can handle?

3. What is the 10GB space in Power BI cloud reffers to ? It is the space of the datasets we publish or size of pbix file?

4. Is there any option of Direct Query for MySQL database? As we all know there is no option but there is any pulgin to install ?

Please help me in this regard and thanks in advance.

-9581736888

[v-frfei-msft · Accepted solution]

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]

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