Hi,
I have a workflow, where I need to reload massive csvs into some BI tool. Of course, it is much easier to do, if data is compressed into some format or written as RAM dump.
1st approach (compressed) is used in Qlik and Tableau, qvd and tde respectively.
2nd approach (RAM dump) is used in Parquet/Arrow (I use it thru Python/Pandas).
Question - Is there _any_ compressed or RAM optimized format, supported by Power BI?
I mean, free easymorph can read qvd and tde (Tableau), but Power BI can't?
Free python/pandas can read/write RAM optimized files, but Power BI can't?
xlsb (binary Excel) is great, but Power BI is extremely slow with it, even it is the MSFT technology.
Also, Power Bi desktop can't read another pbix (at least I don't know how to do this).
Any suggestions? Thanks!