Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Creating Connection in Model by loading from Excel

Dear Community, I have a problem with a query with load data from Excel. The data cannot be loaded because by applying the changes PowerBI gets stuck with the message "Creating Connection in Modell"...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi all,

    thanks for your advice. After starting a new project and reducing the columns in the first step, everything is fine. I created a "main" table for the data load and defined all other queries as reference in this.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi all,

thanks for your advice. After starting a new project and reducing the columns in the first step, everything is fine. I created a "main" table for the data load and defined all other queries as reference in this.

caveman_grug's avatar
caveman_grug
New Member
4 years ago

There is also a simple error that can cause BI to hang at this stage. In your excel file, ensure all columns to the right of your data have been highlighted and deleted even if they appear blank. Excel may be reading all columns as part of the worksheet and BI doesn't like it. This worked for me after trying several other posted solutions regarding changing Options, clearing caches etc.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks! That was it for me, phew! 😄

  • juan_pablo's avatar
    juan_pablo
    Icon for Helper V rankHelper V
    2 years ago

    Great! this was the solution!