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

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