Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Arendp
Helper III
Helper III

Query gives error: Value cannot be null

I have this query:

 

 

 

let
    Bron = Oauth2_18Jan.Contents("https://start.exactonline.nl/api/v1/division/cashflow/Banks"),
    #"XML-bestand geïmporteerd" = Xml.Tables(Bron,null,65001)
in
    #"XML-bestand geïmporteerd"

 

 

 

When loading or refreshing, it gives me this error:

Waarde kan niet null zijn. Parameternaam: accessToken  -> meaning value cannot be null. Parameter name: accessToken

Microsoft.Mashup.Evaluator.Interface.ErrorException: Waarde kan niet null zijn.

Microsoft.Mashup.Engine1.Runtime.Extensibility.ExtensionOAuthFactory.Provider.Microsoft.Mashup.OAuth.IOAuthProvider.Refresh(TokenCredential credential)
bij Microsoft.Mashup.Host.Document.OAuth.OAuthRegistrationService.Refresh(IResource resource, CredentialDataCollection previousCredential)

And the error goes on with this kind of message..

 

Any help on this?

Let me know if you need more info.

 

2 ACCEPTED SOLUTIONS
ImkeF
Community Champion
Community Champion

Hi @Arendp  , 

the function you're using isn't a native M-function. So it might come from a custom connector. You have to contact the person that has created that connector and investigate whats wrong with the authentication.

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

Thanks, I was missing something.... I know what to do now!

 

View solution in original post

2 REPLIES 2
ImkeF
Community Champion
Community Champion

Hi @Arendp  , 

the function you're using isn't a native M-function. So it might come from a custom connector. You have to contact the person that has created that connector and investigate whats wrong with the authentication.

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Thanks, I was missing something.... I know what to do now!

 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors