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
Anand24's avatar
Anand24
Icon for Super User rankSuper User
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