Forum Discussion
Cannot create a measure using Azure Synapse Analytics SQL Table
I was able to resolve the issue. The example I provided was not accurate to create a measure. Thank you for your help.
Community ChampionI am not quite clear what you mean. If you imported the data from synapse, you should have full control.
where are you doing this and how are you connecting? do you get data imported at all?
my exact steps are :
Get Data
Azure Synapse Analytics SQL
I added the Server Name
I added the database
I have tried the connection with both IMPORT and DirectQuery.
The data fully loads and is visible.
I can create visualizations with the data and see the data in the transform data area.
But I cannot create a measure. The table is not recognized when I write a measure.
I was able to resolve the issue. The example I provided was not accurate to create a measure. Thank you for your help.