Forum Discussion

Rakshhit_Sharma's avatar
Rakshhit_Sharma
Advocate I
2 years ago

Dropbox Data Source Error

The scenario is: A xlsb file present in dropbox online folder is currently of size 16 mb. Another file is also being used as data source which is of small size, 6 or 7 mb. both are connected to power...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Rakshhit_Sharma ,

The difference in file size between the XLSB and XLSX formats is due to their structureXLSB is a binary file format, which stores information as raw binary data, making it more compact and faster to read and write12. On the other hand, XLSX is an XML-based file format, which tends to be larger because it stores data as text in XML, which is then compressed.

 

Regarding the issue with your file not refreshing, even though it’s well below the 1 GB or 10 GB limits for free and pro versions respectively. You can read this topic: Solved: power bi file size limits - Microsoft Fabric Community

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Rakshhit_Sharma's avatar
Rakshhit_Sharma
Advocate I
2 years ago

I did some tests, even if i reduce my file size by 3 4 mb , down to 12 13 mb, even then that xlsb file located in dropbox is not connecting properly woth power bi service. On the other hand, if i connect a 50 60 mb xlsx file through the same process, it will connect and refresh smoothly. I am wondering is this any new bug of dropbox or power bi service or windows where xlsb files are not working properly.