Read .gz file in Power BI Desktop

There could be multiple ways to load .gz files in power BI desktop. Instead of decompressing the files, you can read and load .gz file directly in Power BI using R Script. It’s pretty fast and require less line of codes.

Click on Get data option in Power BI Desktop and choose “R Script” and click on connect.

Then use following R Script to load .gz files into power BI Desktop.

install.packages -> data.table
library(‘data.table’)
data <- fread(file=”C:/Users/aansari/Development/Jay/base_BookingsChargesBridge.csv.gz”)
data

Happy coding!!!