Forum Discussion

BenjyPowerBI's avatar
BenjyPowerBI
Frequent Visitor
5 years ago

Matrix with Dynamic Row/Column Headers

Hi!    Let's say I have a table with the columns: ID, Attribute 1, Attribute 2, Attribute 3...  where each of the attribute fields can be either A, B or C in value.    I'm trying to create a matr...
Need Help
BenjyPowerBI's avatar
BenjyPowerBI
Frequent Visitor
5 years ago

Hey Amit,

 

The inclusion of an unpivot table makes the .pbix file size way too big to work with (and publish) so I need a workaround using DAX if possible 😕

PaulDBrown's avatar
PaulDBrown
Community Champion
5 years ago

BenjyPowerBI 

Work with a filtered dataset to reduce the size and reconnect to the full dataset once published

  • BenjyPowerBI's avatar
    BenjyPowerBI
    Frequent Visitor
    5 years ago

    Hi Paul I'm not sure what you mean by this. Please could you elaborate? 🙂 And how can I reconnect to the full dataset after it's been published? 

     

    Thanks in advance!

    • PaulDBrown's avatar
      PaulDBrown
      Community Champion
      5 years ago

      BenjyPowerBI 

       

      Here are a couple of links which will help (I hope!)

      Edit parameters settings in Power BI service 

       

      Change the source of PowerBI datasets dynamically using Power Query parameters 

       

      So basically you create a parameter to filter down the dataset to a manegeable level, and once published, you edit the parameter in the service.

      OR, work with a filtered sample and then alter the source from within the service to pull the whole dataset (as per link number 2)

      • BenjyPowerBI's avatar
        BenjyPowerBI
        Frequent Visitor
        5 years ago

        At the risk of sounding stupid, I'm currently limited to (I think) a 1024MB publishing limit so whenever I try to publish a file with a size greater than that I get blocked. Does this mean that by parameterising it I can bypass this limit?