Power BI connects to Smartsheet stop working

Nhu Ngo

All my Power BI reports connected to Smartsheet stop working since Fri, I can see the list of all Smartsheets, but when try to click on any of that got the error msg

Expression.Error: We cannot apply field access to the type Null.

Details:

  Value=

  Key=rows

Nhu Ngo

I found the issue & everything is working fine now.

As API calls are protected by Require corporate account or MFA policies, it can only work if the domain or email address is on the exempt list.

See the link below for further details

Governance policies for external collaborators | Smartsheet Learning Center

Gillian C

Hi @Nhu Ngo

Within Power BI if you go to your data model, then click the icon for the schedule refresh. Then click 'Data source credentials', there might be an error there, needing you to make the connection between Power BI and Smartsheet again. I've found if you click 'Edit credentials' it reconnects.

Hope this helps.

Nhu Ngo

I've already tried to clear credential & redo it many times, doesn't work. It's not showing even when you try to review data. None of smartsheet works.

Also tried with different user, same issue.

We're using Microsoft Sign in

Ra00

I am experiencing the same issue with two Smartsheet shared by our client, I can access using broswer but cannot access using API ( power bi or python). not sure if this is related to MFA ?

Nhu Ngo

I found the issue & everything is working fine now.

As API calls are protected by Require corporate account or MFA policies, it can only work if the domain or email address is on the exempt list.

See the link below for further details

Governance policies for external collaborators | Smartsheet Learning Center