Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

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

Comments

  • Hi Tony,

    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.
Sign In or Register to comment.