Forum Discussion

Composed_MS's avatar
Composed_MS
Icon for Helper I rankHelper I
3 years ago
Solved

Power BI not giving warning

I have a csv file with 4gb data, when I put it into Power BI desktop, it works fine, as there is no size limit in Power BI desktop, but if I push it into Power BI service and publish the app then als...
Tips and Tricks
  • Anand24's avatar
    Anand24
    3 years ago

    Hi Composed_MS ,
    The size of your .pbix file should be <= 1 GB when you are publishing to Services with PRO License.
    There are techniques to incorporate >1GB dataset as well, please refer this article from Microsoft.

     

    Apart from these, you can try below adjustments:
    1 - Restrict data to have only latest data

    2 - Enable incremental refresh

    3 - Remove unwanted columns, measures, visuals, objects, DAX code lines, etc. from report

     

    Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!

    Proud To Be a Super User !!!
    LinkedIn
R1k91's avatar
R1k91
Icon for Super User rankSuper User
3 years ago

are you sure you're not referring to Dataset size limit that is 1GB for pro users?

if it's the case it doesn't matter how big you source files are, it matters how much of them you load into the dataset and how much vertipaq can compress those data.

you can use DAXStudio to verify the size of your dataset (and the compression ratio) even before publishing it to the service.