Reply
Frequent Visitor
Posts: 8
Registered: ‎01-17-2018

Reading ORC format files

[ Edited ]

Hi,

 

Anyone tried to read ORC format files using PowerBI, We would like to query the data in our Azure Data Lake Store which are in ORC format using PowerBI. Currently not able to read the data, Any help would be appreciated!

Community Support Team
Posts: 2,769
Registered: ‎02-06-2018

Re: Reading ORC format files

Hi alakiran,

 

To achieve data in data lake store, please refer to documentation below:

https://docs.microsoft.com/en-us/azure/data-lake-store/data-lake-store-power-bi.

 

Regards,

Jimmy Tao

Frequent Visitor
Posts: 8
Registered: ‎01-17-2018

Re: Reading ORC format files

Thanks for the response Jimmy, I already tried that article, The data in the data lake store is being stored in ORC format where they will be processed through HDInsight. The PowerBI report is not decoding the ORC format.

Visitor
Posts: 1
Registered: ‎01-30-2018

Re: Reading ORC format files

Hi,

we have the same issue is there any solution jet?

Regards,

JoBa

Highlighted
Frequent Visitor
Posts: 3
Registered: ‎11-10-2016

Re: Reading ORC format files

I don't believe that Power BI can read ORC files directly. You can, however, read the files by using a Hive ODBC connection. You submit queries to Hive, which retrieves the data from the ORC files. This does require an HDInsight or other Hadoop distribution that is online and able to access Azure Data Lake Store.

 

https://www.microsoft.com/en-us/download/details.aspx?id=40886