November 6, 2022
I'm looking for an alternative to CSV files, but unfortunately Power Query can't work with Parquet, but it's possible somehow through an ODBC connection
Has anyone already tried loading Parquet files through Power Query in excel?
Not quite related to the topic, but as an alternative I am also considering the SQLite database. If anyone used, how big is the difference in data size and download speed compared to regular xlsx and csv?
October 18, 2018