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
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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi BenjyPowerBI,

    In fact, query parameters not able to affect this limit.

    It should be a trick to designing a report with fully parameterized connection string reports to skip the publish file size checking.

    After these steps, you can change datasource on the power bi service side, but it not means the 1GB dataset limit has been resolved. If you change on the service side, this size limit issue still exists if your dataset expanded. (dataset size limit has been increased on premium license)

    What is Power BI Premium?#size-considerations 

    Regards,

    Xiaoxin Sheng