Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

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

Topic Labels: Scripting
Solved
Jump to Solution
16410 21
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.

21 Replies 21
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

 

 

ScottWorld
18 - Pluto
18 - Pluto

You may have better luck by using Make’s Microsoft Power BI integrations, along with Make’s Airtable integrations.

If you’ve never used Make before, I’ve assembled a bunch of Make training resources in this thread. For example, here is one of the ways that you could instantly trigger a Make automation from Airtable.

- ScottWorld, Expert Airtable Consultant