I always fail in load to dataset into data model with power query, I have used the same file type and followed every step given in the video but it always fails
Please elaborate. What exactly are you trying to achieve and what doesn't work? Can you share a file with the query(ies) that can't be loaded to the DM?
I want to combine the 3 data and load to data model, but the message "load to data model failed" always appears
Can't really tell why that happens. Occasionally (quite rare), Power Pivot 'hangs up' itself for me, and then I can't use the DM. It's as if the Power Pivot (PP) add-in gets messed up in some way. Then I need to deactivate it in the COM-addin list. Close and restart Excel. Reactivate the add-in and all works again. Give it a try.
what happens when you try to add a regular table from the Excel grid to the DM?
Please include some screenshots showing the steps you take and the error message.
I had no issues in loading the data to PQ and then closing and loading to PP (DM). However when I looked for common fields in PP, I found that one table did not have any common fields.
