Using Dremio, Power Query M Append Function Causes Refresh Issue in Power BI online

Hi All,

I am sourcing data from Dremio into Power BI. However, I have noticed that whenever I append a table that sources Dremio to any other table, it leads to Power BI online not refreshing. The desktop version refreshes fine. Everything else that I have used, including merges do not cause this issue.

this is the error message: Data source errorThe import Dremio.Databases matches no exports. Did you miss a module reference?. The exception was raised by the IDbCommand interface.

Does anyone have an explanation for this phenomenon?

Thanks,

Jason