Forum Discussion

viera00's avatar
viera00
Helper II
10 years ago

Size Of Publishing Compromise Implementation Scenario

Hi Everyone,   I'm having a serious problem with a real implementation scenario.     I've a PowerBI Pro licence.   The architecture is the following:   1- SQL server on premise. 2- Windows ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Have you explored using SQL Server Analysis Services Tabular models? What edition of SQL are you running? 

viera00's avatar
viera00
Helper II
10 years ago

I do not know exaclty the SQL Server Version.

But the customer wants to avoid any new configuration or licence.

So lets assume that SSAS is not avaiable. 

Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    viera00 The only option you have then is to reduce the size of the model by removing elements you may not need. I am not aware of any plans to increase the size of PBI desktop files accepted by the Service. This issue has been brought up many times, and there is a request here which won't help your immediate need.

    If you change your PBIX file extension to .zip you can see the size of all elements of your model. The only way around this size limitation at this point is to either skip the model and direct query the database, or use a tabular or multidimensional model. Both of which require BI or Enterprise level SQL edition.

    Creating a Tabular model is exactly what you are doing in the Desktop file, only it would be re-usable with other reports - so there is really no downside there. Unless they only have "Standard" edition SQL, then you don't really have any options that I am aware of.