Forum Discussion
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
- amitchandak
Super User
aliebrahimi64 , Check if you can still click on Transform data and use it.
Then you can check what is the issue.
- aliebrahimi64Frequent 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