Forum Discussion
How to store Help Text (terms and definitions) into a table visual with proper formatting?
Hi PBIFanHook7
If i understand you correctly you can use Dax qauery view >> funiction info.columns joined to info.table
please refer to the linked blog post :
https://powerbi.microsoft.com/en-us/blog/dax-query-view-introduces-new-info-dax-functions/
Zoe Douglas walks through the exact DAX query needed and shows how it works in practice using the DAX Query ViewIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
One of my other above questions, could I create a Help Report and use the report metadata as a source file? Is there a such thing as a Power BI Report metadata file which contains report column meta data?
Hi PBIFanHook7,
Yes, Power BI does have metadata, but it is not directly accessible in a report. You can retrieve report column metadata using DMV queries if you are using Power BI Premium or an SSAS model by running
SELECT * FROM $SYSTEM.TMSCHEMA_COLUMNS
in DAX Studio, which provides column names, descriptions, and other metadata.
Alternatively, you can manually maintain a data dictionary by storing column definitions in an Excel or SQL table and loading it into Power BI as a reference. Since Power BI does not automatically expose metadata in reports, using an external metadata source is the best approach.
If this solution worked for you, kindly mark it as Accept as Solution and feel free to give a Kudos, it would be much appreciated!
Thank you for using Microsoft Community Forum.
Thanks for the information.