Forum Discussion
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...
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".
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 Thank you this worked!