Smartsheet Connector - Smartsheet Account Owner's Key

[dbalkin777]

Greetings,

I recently joined a team that will be working with some PBI dashboards that connect to a series of smartsheet tables. It looks like, however, that at the 'navigation' step, the report author's smartsheet key is hardcoded in and thus breaking the query view from my end:

I have a few ideas for a workaround, but curious if anyone else has encounted this issue and what, if any, creative workarounds they had working in a team environment.

Thank you.

[v-xinruzhu-msft]

Hi @dbalkin777 

You can refer to the following link, it is similar to the problem.

Solved: Error: The key didn't match any row in the table. - Microsoft Fabric Community

Solved: Expression.Error: The key did not match any rows i... - Power Platform Community (microsoft....

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.