Integration with Hortonworks Hadoop and Security inpersonsation

[mayurkotlikar]

Hi,

I am looking for some pointers to support Power BI service connection to HortonWorks Hadoop via Gateway.

Also is there a way to impersonate a user as AD will is not available for user autherization for RLS.

Regards,

~Mayur

[v-yuezhe-msft]

@mayurkotlikar,

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. After publishing your reports from Power BI Desktop to Power BI Service, you can add ODBC data source under the gateway following the guide in this similar thread, then refresh your dataset.

In addition, I am not very clear about your requirement that impersonate a user as AD, could you please explain it?

Regards,
Lydia

[mayurkotlikar]

Thank you for your response.

Regarding impersonation, right now there is no way to associate the data access with a user. 

i.e. we are looking for a strategy for quering data based on requesting user. 

I will provide more information after looking at the ODBC data source solution your provided and following the blog.

Thank you

regards,

~Mayur

[v-yuezhe-msft]

@mayurkotlikar ,

How is the issue going?

Regards,
Lydia