cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
alakiran
Regular Visitor

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, Any help would be appreciated!

4 REPLIES 4
Anonymous
Not applicable

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

JoBa
Regular Visitor

Hi,

we have the same issue is there any solution jet?

Regards,

JoBa

v-yuta-msft
Community Support
Community Support

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

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.

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.