Problem with refresh

[PerfAgent]

Hi!

I have a data model in power bi desktop, the tables are loaded from two files (.xlsm) on server, and it refreshed data well yesterday.

But today when I click refresh data of the fact table (refresh only one table), it's stucking in "Creating connection in model" 1 hour...

Also, I've examined the table which has no blank columns.

I think that the problem is in the files. Can you help me to understand what a problem?

Maybe you need some additional information?

Thanks,

Alex.

[dramus]

Try switching on Diagnostics (In Options and Settings) and check the logs to see what's going on.

[PerfAgent]

Hi!

I have a data model in power bi desktop, the tables are loaded from to files (.xlsm) on server, and it refreshed data well yesterday.

But today when I click refresh data of the fact table (refresh only one table), it's stucking in "Creating connection in model" 1 hour...

Also, I've examined the table which has no blank columns.  

I think that the problem is in the files. Can you help me to understand what a problem?

Maybe you need some additional information?

Thanks,

Alex.