Forum Discussion
Creating connection in Model is taking too long
Hi, I am trying to create a new report based on a excel file which has 128 Kb. When I try to import it to PowerBi, I can select the worksheet I want work and the next step is to apply query c...
I hope you guys don't mind me hijacking this thread as I have the same problem. Compared to OP, I have 2 Excel files whose file size sum up to 1.39 MB. Power BI has been trying to create a connection to the model for the past 8 minutes as I'm typing this which I find to be unusually long. Is there any way to fix this without me having to delete the dataset?
Hi, to solve my problem I noticed that when try to import the wizard was considering to use the empty columns in my spreadsheet. After I select only usable columns at wizard. The load time improved a lot.
Yeah, mine loaded a lot of empty columns as well. I just "deleted" the empty columns from the source data and it seems to have loaded just fine.