search

migueesc123 / PowerBIRESTAPI

A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API
MIT License
237 stars 74 forks source link

"Expression.Error: The field ‘name’ of the record wasn’t found" when tying to load Dataflow tables #128

Closed JDK1978 closed 2 years ago

JDK1978 commented 2 years ago

Hi,

Many thanks for the excellent Connector. I’m hoping you can assist please…

I am getting an error in the last row of the Dataflow Tables (namely Tables 7,8,9 & 10)…

“Expression.Error: The field ‘name’ of the record wasn’t found. Details: objectId=67e764c8-0311-4fd0-bcc0-72c7993b324c configuredBy=fbrowne@bordgais.ie users=[List]”

…which prohibits me from loading into the model.

In Power Query Editor I can see all the records in these tables but with the final row being ‘error’ across all columns. The ‘Remove error’ and ‘Replace error’ functions won’t resolve this issue.

Can you advise?

Many thanks,

Jonny

klinejordan commented 2 years ago

@JDK1978 have you downloaded the latest version of the connector? This was reported in #106 and fixed in #107

JDK1978 commented 2 years ago

That worked! Many thanks