Hive gateway setup

Hi Manjushree ,

Try to make sure you have the same privacy level security:

In Power BI Desktop:

Options and Settings --> Data Source Settings

For every Datasource: -->  Edit Permissions

Set Privacy Level: e.g. „Organizational“

Power BI Service:

Datasets --> (Choose you Datasets which does not update properly) --> settings --> Gateway Connection --> Actions --> (expand you cluster to show all Data Sources) --> (Choose relevant Datasource) --> Advanced Settings --> Privacy setting --> set same level (e.g. „Organizational) as in Power BI Desktop

You can create ODBC data source for cloudera hive, then connect to the ODBC data source in Power BI Desktop, then publish it to service, add ODBC data source under the gateway following the guide in this similar thread, then checkif it works.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien