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 Anonymous ,

 

Column limit - The maximum number of columns allowed in a dataset, across all tables in the dataset, is 16,000 columns. This limit applies to the Power BI service and to datasets used in Power BI Desktop. 

 

Check whether the data you import is greater than 1GB, about optimizing the data source, you can refer to

Data reduction techniques for Import modeling - Power BI | Microsoft Docs

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks for this information. I have started building up a new projekt and now it works better. It was some issue with too many dataloads