Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Creating connection to the model

Hello everyone I am trying to update a PBI file but I stay for hours in "creating connection to the model", I already checked my excel files, they continue as they have always been, I also tried...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    5 years ago

    Thanks to everyone I solved it!!! It was because I was reading columns to infinity of a file, so if this happens to you also check the columns that do not have information, in order to delete them.

ponnusamy's avatar
ponnusamy
Solution Supplier
5 years ago

Can you disable the Data load setting as shown below and try again?

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago

It doesn't work for me, I did all those steps and it's still been about 30 minutes with the theme of creating connection to the model. I have other GDPs and everyone else is good for me.

  • ponnusamy's avatar
    ponnusamy
    Solution Supplier
    5 years ago

    Do you have the Excel files on your local computer or are they on a shared drive , sharepoint etc.?. Try to load one excel file without any relationship using a new PBIX file.

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      5 years ago

      I do have the files on a sharepoint drive, but it makes it difficult for me to leave it unrelated, because they are files that are updated by other people the same.