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
Rakshhit_Sharma's avatar
Rakshhit_Sharma
Advocate I
2 years ago

Also one thing more, the xlsb file i am using as my data source is of currently 16 mb .  if we convert it to xlsx format, it will change to size of 43 mb. any reason why the service the file of such small size. Acc. to their online resources ,  max size of 1 gb and 10gb is acceptable for free and pro versions. then why mine is not refreshing ?

  • 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.