Shane T. McFarland on 17 Oct 2017 02:58:39
In relationship view, add a section in 'Resources' called 'Reference File Template' [or similar], designer clicks button -> pBI Desktop pulls all the headers and tables [data sources] together into an 'Outline' template in Excel, with the hierarchy relationship [each table from the same server, database in their own groups], pathway for each table [server, db, table/view/ etc.] already recorded, the synonyms already created, and added columns for descriptions of each header that the designer can edit. The completed file would be able to be attached to the reports/dashboards when uploaded, so end users have insight into what the data is for more complex visuals and data.