Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to Solution.
I was able to resolve the issue. The example I provided was not accurate to create a measure. Thank you for your help.
can you post a screenshot of what you get when you try to create a measure, also can you share your model?
Proud to be a Super User!
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?
Proud to be a Super User!
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.
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |