Forum Discussion

nmasimore's avatar
nmasimore
Icon for Helper I rankHelper I
4 years ago
Solved

Need PBI to Continue Refresh if a Particular Dataset Refresh Fails (Try-Otherwise) - ODBC/OLE Error

Hello!   I have built an M-Query script (lets call it Script A) that combines Excel spreadsheets in an on-premises folder into one large table. However, if one of these excel spreadsheets is format...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Are you combining Script A and Script B together?

     

    If so, I think you'll have more luck returning an empty table rather than a string. That is, #table({},{}) instead of "failed".

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Are you combining Script A and Script B together?

 

If so, I think you'll have more luck returning an empty table rather than a string. That is, #table({},{}) instead of "failed".