Power Query: Cannot create Data Model from connections.

Question

Scenario 1: Get data from excel workbook ->Transform and load to -> Connections Only.
Result: Works properly

Scenario 2: Get data from Folder ->combine & Transform and load to -> Connections Only.
Result: Works properly

Scenario 2: Get data from Folder ->combine & Transform and load to -> Connections Only + Add this to Data model
Result: Not working! Keeps on loading. I cannot start my project.

Answer 1

Hello Cloyd,

Unfortunately, I don't have any further troubleshooting to offer.

There are many knowledgeable users active on the forum and I hope that someone else can offer further insight into your issue.

Thanks IBHADIGHI

Answer 2

Hello Cloyd, I'm Ibhadighi and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself. Here are some general troubleshooting steps you can try: Make sure your version of Excel is up to date. Try clearing the cache in Power Query by going to File > Options and Settings > Data Load > Clear Cache. If you’re using a 32-bit version of Excel, try switching to the 64-bit version, as it can handle larger data sets. I hope one of these solutions helps resolve the issue for you. Best Regards, IBHADIGHI

I did this one already. But the issue still persists. See attached photo.

Keeps on loading until it doesnt respond anymore

Answer 3

Hello Cloyd,

I'm Ibhadighi and I'd happily help you with your question. In this forum, we are Microsoft consumers just like yourself.

Here are some general troubleshooting steps you can try:

Make sure your version of Excel is up to date.

Try clearing the cache in Power Query by going to File > Options and Settings > Data Load > Clear Cache.

If you’re using a 32-bit version of Excel, try switching to the 64-bit version, as it can handle larger data sets.

I hope one of these solutions helps resolve the issue for you.

Best Regards, IBHADIGHI

Answer 4

Scenario 1: Get data from excel workbook ->Transform and load to -> Connections Only.
Result: Works properly

Scenario 2: Get data from Folder ->combine & Transform and load to -> Connections Only.
Result: Works properly

Scenario 2: Get data from Folder ->combine & Transform and load to -> Connections Only + Add this to Data model
Result: Not working! Keeps on loading. I cannot start my project.

Also, I am using IdeaPad 3 15IIL05

Processor Intel(R) Core(TM) i5-1035G1 CPU @ 1.00GHz 1.19 GHz

Installed RAM 12.0 GB (11.7 GB usable)

Device ID FAF451AB-D2F0-4B0D-B90E-C2B00298E2B7

Product ID 00327-30894-85127-AAOEM

System type 64-bit operating system, x64-based processor

Pen and touch No pen or touch input is available for this display

Please help. Thank you!