We cannot convert the value "[Record]" to type Record

[Anonymous]

Hi,

I get this error message when I refresh my dataset at power bi web.

I have no problem refreshing it at Power BI Desktop.

The error happens when I merge any table and expand the records, if I take those steps away it refresh the data at power bi web with no problem but I need the tables to merge.

Any idea 

[v-piga-msft]

Hi @Anonymous,

What is your data source?

What kind of Power BI Gateway do you use in Power BI Service?

To get the solution, you'd better share your M query in Query Editor so that I could have a test.

In addition, you could have a reference of this similar thread.

Best Regards,

Cherry