Forum Discussion
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"...
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.
The data is collected from several companies (espiacially insurances) The data is deliverd per company and for reporting year
smpa01
Community Champion
Community ChampionAnonymous can you get them from a db? If yes, you can do the transformation server side and only bring what you need