Share via

PowerBi Desktop Fails to Load all data for one user but not another

Lefever, Ian (10300) 1 Reputation point
2022-08-11T14:30:32.377+00:00

Hello -

Recently I built someone a PowerBi dashboard using the PowerBi desktop app that I have been refreshing daily for about three months. I now am attempting to transition that responsibility to another user. After sending all of the relevant files and updating the data source settings the dashboard appears to fail to refresh. More specifically, at what appears to be about 170-200MB/ 450k rows it generates an error and reacts like the rest of the data set is blank. I have checked the source csv and it appears to contain all of the necessary data. When I refresh the dashboard on my machine, the file appropriately brings in the full ~800MB of data without error.

Additional Information
Dashboard references two files
File 1 - CSV file with about 2M rows and 800MB
File 2 - Excel file, 2 columns with about 80 rows of information

There is minimal transformation and about 10 calculated fields throughout.

If anyone has an idea as to the issue, it would be greatly appreciated. Thanks!

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
37,794 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Dillon Silzer 56,681 Reputation points
    2022-08-11T14:48:31.483+00:00

    Hi @Lefever, Ian (10300)

    I would recommend posting this on the dedicated PowerBI Desktop forums found at https://community.powerbi.com/t5/Desktop/bd-p/power-bi-designer and you will get more expertise in this topic.

    ------------------------------------

    If this is helpful please accept answer.