Help

Airtable to Power BI using Personal Access Token "cannot convert the value null to type Record

Topic Labels: Scripting
Solved
Jump to Solution
13965 20
cancel
Showing results for 
Search instead for 
Did you mean: 
Rhode_Ninja
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello Community,

First post here. I am attempting to connect my Airtable to Power BI.

I am receiving the following error message in Power BI

  • Expression.Error: We cannot convert the value null to type Record.
    Details:
    Value=
    Type=[Type]

I am following this guidance and using a Personal Access Token. I setup Power BI Parameters successfully but received the error code in the Query. I suspected that it may be the M Code so I followed a link to a GitHub resource for alternate code.

  • "If the above script seems to be causing an error, then please refer to this GitHub resource, as the code may have changed.

I have tried both versions of the M code.
I don't know enough about tracking down this error code. Any ideas of what it might be?
All assistance is greatly appreciated.

20 Replies 20
Yerko_Begic
6 - Interface Innovator
6 - Interface Innovator

For Authentication, it is recommended to use "Anonymous" which doesn't work for me no matter what

Yerko_Begic_0-1728591783732.png

 

My Date Source Settings on current file as well as Global are all set to Anonymous

Yerko_Begic_1-1728591783800.png

 

Yerko_Begic_2-1728591784203.png