Forum Discussion
Error when connecting to Azure HDInsight Spark with Power BI Pro
Solved this: turns out HDInsight was accepting a >20char password at instance creation (and for instance login) but was rejecting it when passed via Power BI. Somewhere there's probably clipping going on. Reducing my password down to <= 20chars fixed the Power BI connection issue.
In case Power BI Support is reading this: it would be great if the error was more descriptive, as it was unclear if the issue was connecting to the service or authenticating. Had I known it was an authentication issue I would have found the solution much faster, but the "We are unable to establish connection" text implied it was a connectivity issue.
Solved this: turns out HDInsight was accepting a >20char password at instance creation (and for instance login) but was rejecting it when passed via Power BI. Somewhere there's probably clipping going on. Reducing my password down to <= 20chars fixed the Power BI connection issue.
In case Power BI Support is reading this: it would be great if the error was more descriptive, as it was unclear if the issue was connecting to the service or authenticating. Had I known it was an authentication issue I would have found the solution much faster, but the "We are unable to establish connection" text implied it was a connectivity issue.