Scheduled refresh for HDInsight source

[Sumanth_23]

hi, I have a requirement to connect to HDInsight data source and build out a report. I have followed the steps to create a ODBC connection to connect to the data source and built out a couple of reports. 

The issue is that when I publish the the dataset to the service - the scheduled refresh setup fails as it does not recognize the credentials used for the ODBC connector setup. 

Is there any additional specific setup required to schedule refreshes for HDInsight or is this a limitation at this point?

Thanks for you help!

Sumanth 

[collinq]

Hi @Sumanth_23 ,

This thread from years ago talks about how to do it:

Visualize big data with Power BI and Spark on Azure HDInsight | Microsoft Power BI Blog | Microsoft ...

And an update:

Tutorial: Analyze Azure HDInsight Apache Spark data with Power BI | Microsoft Docs

And, here is a more recent article:

Visualize Apache Hive data with Power BI - Azure HDInsight | Microsoft Docs

[Sumanth_23]

hi @collinq - Thanks for the response - let me check if this helps solve the refresh issue and shall keep you posted!