Smartsheet Connector - Smartsheet Account Owner's Key

Question

Greetings,&nbsp;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:&nbsp;&nbsp;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.&nbsp;Thank you.&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;dbalkin777&nbsp;
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.com)
&nbsp;
Best Regards!
Yolo Zhu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.
&nbsp;

Forum Discussion

Related content

Connecting to Australian-hosted Smartsheet data

Connecting Multiple Smartsheets

Connect Smartsheet Resource Management API to PBI

PowerBi - Smartsheet Integration

Smartsheet File moved to another folder