Connecting to Azure Synapse Analytics workspace through Power BI

[aliebrahimi64]

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"

[aliebrahimi64 · Accepted solution]

@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

[amitchandak]

@aliebrahimi64 , Check if you can still click on Transform data and use it.

Then you can check what is the issue.