Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Report 'Table'
Hi
I like the way you separated all the measures from the tables and put them in Report. I would like to do the same in my dashboards however I'm not sure how to create the actual Report 'table' itself. Can you help? Also any downside of your methodology, I can't think of one.
Thanks in advance
Tony
I like the way you separated all the measures from the tables and put them in Report. I would like to do the same in my dashboards however I'm not sure how to create the actual Report 'table' itself. Can you help? Also any downside of your methodology, I can't think of one.
Thanks in advance
Tony
Comments
In Excel I have table in src worksheet, column BA that has just header no record. Then this table is loaded as linked table into PowerPivot model. In Excel 2013/2016 I mark it in connection "Refresh this connection on Refresh All" as no (unchecked). This table has no relationships in PowerPivot model to any other table.
In PowerBI this is loaded as static table.
I have not seen any issues with such design.