Forum Discussion

alakiran's avatar
alakiran
Regular Visitor
8 years ago

Reading ORC format files

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, A...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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