Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Tors
Frequent Visitor

Datatype not showing in calculated table using INFO.VIEW.MEASURES()

Hello, 

I am looking to use the INFO.VIEW.MEASURES() within a calculated table.
When I run the command via DAX Query View there is no issue. 
However, when I use it within a calculated table the datatypes are all shown as Blank.

Is this a known issue/limitaion or does anyone know of a fix?

Datatypes in DAX Query View using INFO.VIEW.MEASURES()

Tors_1-1738840485727.png


Datatypes in Calculated Table using INFO.VIEW.MEASURES()

Tors_2-1738840599054.png



Thank you!

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @Tors  - Yes, this is a known limitation when using INFO.VIEW.MEASURES() inside a calculated table in Power BI.

Use INFO.VIEW.MEASURES() in DAX Query View for Debugging

If your goal is to inspect measures and their datatypes, running the query separately in DAX Query View is the best option.
Store the Output in an External Table

Instead of using it in a calculated table, consider exporting the output from DAX Query View and loading it as a separate dataset.
Manually Assign Data Types

If you still want to use it in a calculated table, create a new column to manually assign datatypes based on measure names.

 

Hope this works.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
rajendraongole1
Super User
Super User

Hi @Tors  - Yes, this is a known limitation when using INFO.VIEW.MEASURES() inside a calculated table in Power BI.

Use INFO.VIEW.MEASURES() in DAX Query View for Debugging

If your goal is to inspect measures and their datatypes, running the query separately in DAX Query View is the best option.
Store the Output in an External Table

Instead of using it in a calculated table, consider exporting the output from DAX Query View and loading it as a separate dataset.
Manually Assign Data Types

If you still want to use it in a calculated table, create a new column to manually assign datatypes based on measure names.

 

Hope this works.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Thank you for your help. 
Do you happen to know if its on the road map to be fixed?

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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