Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I'm trying PowerBI embedded under the following conditions.
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?
Solved! Go to Solution.
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.
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.