Forum Discussion

aliebrahimi64's avatar
aliebrahimi64
Frequent Visitor
3 years ago
Solved

Connecting to Azure Synapse Analytics workspace through Power BI

Hi,
When I want to pull data from Azure Synapse Analytics workspace through Power BI, I can see the tables but when I click on the table to see their values I get this error:
"Expression.Error: We cannot apply field access to the type Null. Details: Value= Key=StorageDescriptor"

 

  • amitchandak I figure out the problem is with the connector. I tried using “Azure Synapse Analytics SQL” instead of "“Azure Synapse Analytics workspace (Beta)”" and it works now.
    Thanks by the way

2 Replies

  • aliebrahimi64's avatar
    aliebrahimi64
    Frequent Visitor

    amitchandak I figure out the problem is with the connector. I tried using “Azure Synapse Analytics SQL” instead of "“Azure Synapse Analytics workspace (Beta)”" and it works now.
    Thanks by the way