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.
I saw some references to a maximum of a million record issue related to the topic, but two weeks ago, I was able to import like 30 million records from our database and the Excel files referred did not change.
Manually refreshes on a selection of tables works, refreshing those tables that fail one by one does work, do it all at once results in a failure. Got back to the November version, still a problem. Different computer, still a problem. Removing the million+ tables from refresh and put a "remove blank rows" on all Excel files, still a problem.
What am I missing?
Solved! Go to Solution.
Turned out that one of the Excel files I receive from another contained the maximum number of columns possible, even though they are not in use. "Remove other columns" turned out to be the solution.
Turned out that one of the Excel files I receive from another contained the maximum number of columns possible, even though they are not in use. "Remove other columns" turned out to be the solution.
Hi @DouweMeer ,
There is no volume limitation for a load for either DirectQuery or Import. DirectQuery has a limit of rows behind each visual - 1 mln, but Import has no such limit. You have a limit for Import mode - memory usage limited to your computer resources (RAM). So if you have 8 GB of RAM and your report consumes 9 GB then it will fail. You can check usage via Windows Task Manager -> Resource Monitor (https://www.digitalcitizen.life/how-use-resource-monitor-windows-7)
Best Regards
Lucien
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
81 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |