I used fn_ReadDeltaTable.pq (approach 1) in my PBI report to connect delta lake. It works fine on my desktop. Then I published report online and refreshed the dataset automatically thru schedule. However the refresh of dataset fail about once per week. Typical error is Error: We cannot convert the value [ccon]null[/ccon] to type Table.. [/ccon]. Another error is The 'null' column does not exist in the rowset.
Everytime I download the report, refresh the data on desktop, republish will fix it. Do you know how to resolve it permanently?