Reply
ED2024
Frequent Visitor
Partially syndicated - Outbound

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. The tabel is not recognized. The data itself is visible but it doesn't see like I can do anything else with it.

 

So for example:

A simple measure like:

Measure = UPPER('Table'[Column])

 When I try to enter table name, nothing appears.

When I try just calling a column name, nothing appears.

 

Configuration wise:

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 but no luck.

 

Any advice?

 

 

 

 

1 ACCEPTED SOLUTION
ED2024
Frequent Visitor

Syndicated - Outbound

I was able to resolve the issue. The example I provided was not accurate to create a measure. Thank you for your help. 

View solution in original post

4 REPLIES 4
vanessafvg
Super User
Super User

Syndicated - Outbound

can you post a screenshot of what you get when you try to create a measure, also can you share your model?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




vanessafvg
Super User
Super User

Syndicated - Outbound

I 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?  





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Syndicated - Outbound

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.

 

ED2024
Frequent Visitor

Syndicated - Outbound

I was able to resolve the issue. The example I provided was not accurate to create a measure. Thank you for your help. 

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)