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

I'm going to guess that yes, 3000 columns might not be ideal for a tabular model.

 

--Nate

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!

  • PedroPascual's avatar
    PedroPascual
    Icon for Helper I rankHelper I
    3 years ago

    Anyone has a new solution for this topic??