Forum Discussion

Brendan151's avatar
Brendan151
Frequent Visitor
2 years ago

Read from Semantic Model with Spark SQL

I'm trying to use a notebook to read data from a sematic model in a different workspace to the notebook. Following the guide here: https://learn.microsoft.com/en-us/fabric/data-science/read-write-po...
Need Help
Brendan151's avatar
Brendan151
Frequent Visitor
2 years ago

Hi v-cboorla-msft 

 

Thanks for your reply. 

 

I am using the latest version of SemPy but the documentation confirms SemPy is not needed for this and I have confirmed the ID matches that shown in the UI.

 

spark.conf.set("spark.sql.catalog.pbi", "com.microsoft.azure.synapse.ml.powerbi.PowerBICatalog")
spark.conf.set("spark.sql.catalog.pbi.workspace", "<ID>")

spark.sql("SHOW TABLES FROM pbi").show(1000, truncate=False)

 

I am not sure where to add a Configured by element?

 

Thanks.

v-cboorla-msft's avatar
v-cboorla-msft
Microsoft Employee
2 years ago

Hi Brendan151 

 

Inorder to understand the exact issue, it requires a deeper investigation from our engineering team about your workspace and the logic behind it to properly understand what might be happening. 

Please go ahead and raise a support ticket to reach our support team: support-ticket 

Please provide the ticket number here as we can keep an eye on it.

  • v-cboorla-msft's avatar
    v-cboorla-msft
    Microsoft Employee
    2 years ago

    Hi Brendan151 

     

    Following up to see on the last response whether you got a chance to create a support ticket. If yes please provide the ticket number here as we can keep an eye on it.

    Otherwise, will respond back with the more details and we will try to help.


    Thanks

    • Brendan151's avatar
      Brendan151
      Frequent Visitor
      2 years ago

      Thanks, I have raised a ticket with support (2402130030001207).