Skip to main content

    Power BI

    New

    Append Excel table located on OneDrive with Oracle on prem. data in a query and refresh in Power BI Service

    Vote (1) Share
    Chris's profile image

    Chris on 16 Nov 2017 03:45:29

    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.