Power BI connects to Smartsheet stop working
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
Best Answer
-
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
Answers
-
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.
-
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
-
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 ?
-
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
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 213 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives