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 have 70+ CSVs in blob storage. I am trying to load these into PBI using "combine files" and in powequery everything looks good. I close PQ and load in PBI and it always gets stuck on the "refresh" dialog box when loading the data at the 127mb mark (about 1.5GB of files are in blob storage)
It doesn't seem like a timeout as the data loads super quick up to the 127mb mark and just stops, every time I click refresh.
Maybe there's an inconsistency in one of the CSVs, If that's the case it should still load but say there were "x errors" in PQ. how can I troubleshoot this and load all data?
You could check the Issues forum here:
https://community.powerbi.com/t5/Issues/idb-p/Issues
And if it is not there, then you could post it.
If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Thanks, I've raised a ticket.
I have now noticed that if I wait long enough (say, 10-20 min) it gets past the initial "hang", loads a few more MB (maybe up to 100mb) and then hangs again for 10-20mins.
I've removed all files exept for 2 CSVs of which total about 3mb. They take about 20 mins to load with the hangs. It happens on 100mbit connection and also on a mobile connection, so networking is not the issue.
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 |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |