Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
ckcampbell248
Regular Visitor

Dataset won't refresh from Blob Storage

I have a Power BI file published to the service from Power BI Desktop. The data in the model is retrieved from Azure Blob Storage. I can refresh the model in Power BI Desktop with no issues. However, when I try to refresh it after publishing the model to PowerBI.com I get the error "An error occurred while processing the data in the dataset".

 

I have four files in one container all in .csv format that are combined in the query using combine binaries and two individual files in Excel format on a separate conainer that are accessed individually and loaded as tables.

 

I have updated the credentials on PowerBI.com to include my Azure Blob Storage key.

 

Are there any differences or requirements when refreshing from blob storage in the PowerBI.com service? For example, do I need to save them with different encoding or is Excel format not supported?

1 REPLY 1
ckcampbell248
Regular Visitor

To add on to my own topic, the issue seems to be with data volume. I have five files in the blob storage container that add up to about 580 MB. I can refresh the report if I include only three of them (so between 300 and 400 MB). As soon as I add in the fourth file, the refresh fails. I have tried with different sets of files and I have refreshed from each individually so I don't believe that the problem is with any one file. So far, it seems like, if I keep the amount of data under 500 MB, it will refresh fine. If I use

 

Is there a size limitation on the amount of data that can be refreshed from blob storage?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors