Trouble importing CSV into existing model....but imports beautifully on new model

[charleshale]

1. Set up:

- Azure VM Windows 10, Version 2 specifically for PowerBI

- 192 gig RAM, 48 vCPUs, premium disk. Files on OneDrive Business but they seem to store locally on the VM's C drive so I used the Premium SSD with 300 Gig ----- Basically I have thrown needlessly huge compute power at this to eliminate compute as the bottleneck.   (Note - I'd like to learn how to use azure data tables so maybe I dont have to import large CSVs but havent gotten there yet)

-  major files are all CSVs.  There are only 2 large ones:  7m rows @1.5 gig and 15m rows @2.6gig

- These data refresh and privacy settings followed.

- I've tried breaking up the CSVs into small files and using Import/Folder but this doesnt seem to make a difference

2. The unexpected behavior

- The files each import clean and fast into fresh powerBI instances.  However, when I import them into an existing model, the files hang forever in trying to establish a connection to the CSV

- Another odd thing is that the files can import fine until PBIX crashes and then I get all sorts of problems thereafter that dont seem to resolve unless I start afresh.

[v-diye-msft · Accepted solution]

Hi @charleshale 

Please disable below functions and try again:

If not help, maybe the trace will tell us something. Can you go into Options -> Diagnostics -> Enable tracing. Perform your scenario again and then send us the trace files (in the same panel, click "Open trace folder" and send everything captured in the scenario, you can see the timestamp. There won't be any data logged in the trace files)