Forum Discussion
Datatype not showing in calculated table using INFO.VIEW.MEASURES()
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 TableInstead 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 TypesIf 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.
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.
Thank you for your help.
Do you happen to know if its on the road map to be fixed?