- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 bi as data source in same way: their share links are copied and pasted as web data source , the "dl" thing is changed from 0 to 1 and excuted after that. The dashboard with small file is updating and working perfectly. Even the service refresh happens smoothly in no time. But problem has come for the large file. Initially it was working fine, but i guess, after its size has crossed 15 mb mark, direct access and refresh in power bi service has been stopped. In semantic model settings for that big file report, it is asking to convert that specific workspace to Premium[currently it is at pro]. Any suggestions what else i can do to again connect and refresh my dashboard in service directly from dropbox online. Any suggestions will be helpful
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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 ?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
That this is the file size limit with power BI Pro. You would have to either upgrade your license to premium per user or reduce the file size to less than 15 MB.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks for the info. Any other option available to me in my current scenario. Also, if i have to convert that workspace to premium, will that affect any existing admins managing it. Some have pro or free license of power bi service. Thanks once again for the information.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
People who consume from this workspace will then also need to get a premium per user licence. Nothing will be deleted. or changed it will still work as expected.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Any other option available , cause there are many people attached to that workspace. Only 2 edit it , rest just refresh the report and view it. Converting their license will be a long method. Any other way.

Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - February 2025
Check out the February 2025 Power BI update to learn about new features.

Subject | Author | Posted | |
---|---|---|---|
03-11-2021 12:47 PM | |||
08-10-2022 11:01 AM | |||
01-23-2024 01:01 AM | |||
09-01-2021 04:11 PM | |||
08-17-2023 01:26 PM |
User | Count |
---|---|
40 | |
35 | |
34 | |
27 | |
26 |
User | Count |
---|---|
39 | |
25 | |
24 | |
21 | |
17 |