topic Re: PowerBI Embedded connection string for HDInsight SparkSQL in Developer

PowerBI Embedded connection string for HDInsight SparkSQL

moris — Fri, 09 Dec 2016 13:04:29 GMT

I'm trying PowerBI embedded under the following conditions.

Datasource is HDInsight SparkSQL
Direct Query

I upload pbix file to my workspace and I'd like to update connection string into for dataset. But I don't know connection string for Spark SQL. Does anyone know Spark SQL connection string?

Re: PowerBI Embedded connection string for HDInsight SparkSQL

Eric_Zhang — Mon, 12 Dec 2016 05:17:34 GMT

@moris

As of now, only Azure SQL DB and Azure SQL DW support DirectQuery mode in Power BI Embedded. So I'm afraid you can not set up an DirectQuery to HDInsight SparkSQL in Power BI Embedded.

You can check this idea Support other data sources Direct Query using Gateway on Embedded Power BI and vote it up.