Power BI not giving warning

[Composed_MS]

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 also it does not give any warning or error.

On many platforms it shows csv size limit is 1gb in Power BI service. So I am worried as should I continue using this file or not. As it is working fine now I don't want it to suddenly give me an error one day.

[Anand24 · Accepted solution]

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]

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.