Followed this to the letter with a little help from Airtable Query . Tried multiple tables keep getting the same error.
Expression.Error: We cannot convert the value null to type Record.
Details:
Value=
Type=[Type]
Visualizing Airtable records in Microsoft Power BI & Power Query
+1
+13
This error within Power BI usually occurs if the user did not apply the correct data source settings within the Power BI configuration. Please take a look at this FAQ from our support article for more information on this error. You'll want to ensure that the proper source settings are applied. To check please try the following:
- In Power BI, navigate to Options and Settings -> Data source settings -> Edit Permissions -> then change Credentials Type to Anonymous from Windows.
If the issue persists, we recommend reaching out to Power BI support to further troubleshoot if there other settings that may be misconfigured.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.