PowerBI Embedded connection string for HDInsight SparkSQL

[moris]

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?

[Eric_Zhang · Accepted solution]

@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.