Forum Discussion

rhayward2209's avatar
rhayward2209
Icon for Helper I rankHelper I
5 years ago
Solved

key didnt match any rows in the table all.

Hi all,   I have inherited a Power BI dashboard that pulls data from multiple excel files in a sharepoint folder to get its data. When I add new excel files to this sharepoint folder I get the "key...
Need Help
  • Jimmy801's avatar
    Jimmy801
    5 years ago

    Hello rhayward2209 

     

    this error is normaly caused when accessing a sheet of your file. Please ensure that sheets are called the same. You can also post the M-code here then I can anaylse it for you

     

    If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
    Kudoes are nice too

    Have fun

    Jimmy

Jimmy801's avatar
Jimmy801
Icon for Community Champion rankCommunity Champion
5 years ago

Hello rhayward2209 

 

this error is normaly caused when accessing a sheet of your file. Please ensure that sheets are called the same. You can also post the M-code here then I can anaylse it for you

 

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy