Excel Forum • My Online Training Hub

Power Query and Parquet Files

Vladislav Levchenko

New Member

Members

Forum Posts: 2

Member Since:
November 6, 2022

Offline

December 27, 2022 - 10:18 am

Hi!

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?

Alan Sidman

Steamboat Springs, CO

Member

Members

Forum Posts: 123

Member Since:
October 18, 2018

Offline

December 28, 2022 - 8:43 am

crossposted: https://www.excelforum.com/exc.....files.html

Please read: https://excelguru.ca/a-message.....s-posters/

The following users say thank you to Alan Sidman for this useful post:

Philip Treacy

Forum Timezone: Australia/Brisbane

Most Users Ever Online: 170

Currently Online: Ivan Kulubya

Guest(s) 59

Currently Browsing this Page:
1 Guest(s)

Top Posters:

SunnyKow: 1431

Anders Sehlstedt: 845

Velouria: 574

Purfleet: 412

Frans Visser: 346

David_Ng: 306

lea cohen: 213

A.Maurizio: 202

Aye Mu: 201

Jessica Stewart: 185

Newest Members:

Vicky Otosnika

Abhishek Singh

Kevin Sojourner

Kara Weiss

And Woox

Armani Quenga

moshood bello

annelies b

James1989

lucy gilmour

Forum Stats:

Groups: 3

Forums: 24

Topics: 6045

Posts: 26523

Member Stats:

Guest Posters: 49

Members: 31492

Moderators: 2

Admins: 4

Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT

Moderators: MOTH Support, Riny van Eekelen