To much Data für Power Bi Desktop?

[EH_18]

Hi everyone,

I just started working with the Microsoft Power Bi Tool. For testing the tools capacity and usability I got two big CSV Files from my boss. One is about 1,6GB and the other ist about 700MB. Database is MySQL. 

As I read that the maximum capacity of a Power Bi table is 1GB the import of the whole dataset didn't work. In the next step I got the 1,6GB CSV subdivided in years (2014-2018). I was able to import those in one analysis because each is smaller than 1GB and I also was able to connect them by the ID-number of the orders. Now I have four tables all including the same data but for several years. Because of the relationship management it is possible to connect them while analyzing, but instead of having just one field for example the ean-number there are now four of them (for each year).

I'm not really into all this technical stuff so I need help solving my problem. Is it possible to connect the four year-based tables to a big one again, so that all the several information is distilled in one field again? I also tried to connect the Power Bi with MySQL directly, but I wasn't able to because of any administrational rights.

I hope you might understand what I tried to say explaining my problem and also might help me solving it.

Thanks in advance! 🙂

[Anonymous · Accepted solution]

Hi @EH_18,

Getting adminstrational rights to MySQL might be what you need.

However, there is a quick work-around. If you have four different tables in the same format with the same column headers, you can just append them and use the appended table in your report. I.e. make sure that all the column headers are equivalent in each of your 4 tables, append them and you should be left with one table with all 4 tables combined.

Hope this helps,

T