Append Excel table located on OneDrive with Oracle on prem. data in a query and refresh in Power BI Service
I have a data model that has one query that pulls data from an Excel table saved to OneDrive (SharePoint Online) and another query that pulls data from an Oracle table. I am able to append those two tables together in Power BI Desktop and refresh. However, when I publish the model to Power BI Service this append step breaks the ability to enable refresh on the enterprise gateway.