Showing results for 
Search instead for 
Did you mean: 
lmsung New Member
New Member

Integration with Hortonworks Hadoop via DirectQuery

Hi all, new to Power BI here and looking to connect it to an Azure cloud-based Hortonworks Hadoop Data Lake. This would be via DirectQuery, without storing data outside the Hadoop cluster, due to regulatory considerations. There would also need to be some sort of a reporting server as well to create the reports for end users to consume. 


My main questions:

1. Is DirectQuery only possible against Spark and not Hive in a standard Hortonworks distro?

2. From the literature, the Reporting Server is an on-premise reporting machine. Is there a cloud equivalent as I do not want to expand my on-prem infrastructure - is this what Power BI Service is?

3. What changes are happening in Q1 2018 in terms of hosting Power BI Premium workspaces on different O365 tenants? Our corporate tenant is in a different global region, and it would be ideal if we could host within our region, rather than have to have network hits of such distance.


Moderator v-yuezhe-msft

Re: Integration with Hortonworks Hadoop via DirectQuery


Firstly, it doesn't support DirectQuery mode for Hortonworks Hadoop in Power BI Desktop, you can check the supported data sources in this article.

But you can create ODBC data source for HortonWorks Hadoop following the instructions in this blog, then connect to the ODBC data source in Power BI Desktop.

Secondly, you can publish your reports from Power BI Desktop to Power BI Service, and add ODBC data source under the gateway following the guide in this similar thread, then refresh your dataset.

Thirdly, there is no official article stating the Q1 2018 changes about Power BI Premium workspaces on different O365 tenants.


Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)