Forum Discussion
Cannot create a measure using Azure Synapse Analytics SQL Table
I created a PBI report using share point files and power automate. I now have been asked to make the data source for PBI point to an Azure Synapse Analytics SQL Table. When I try to create 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.
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.