Before applying the changes in the Excel OData report, please ensure that:

  • The queries in the Excel OData report refer to Web Service Pages (which is represented by tables in the Linc Data Warehouse) and not queries (which can not be included in the Linc Data Warehouse), and
  • The tables of the referenced Web Service Pages in the Excel OData report are setup in BC to be included in the Linc Data Warehouse.


1. Investigate the queries in the Excel OData report to determine if they reference tables which can be included in the Linc Data Warehouse by opening the Power Query Editor and selecting the Source step of the query:




2. Find the entity (Freighter_Trip_Legs - highlighted above) referenced in the query source step on the BC Web Services page to determine if it is a page/table:


3. Ensure that the page/table is setup on the Linc Data Warehouse Entities page in BC to be included in the Linc Data Warehouse to be used in the report:



If the page/table has not been setup on the page above, please do so and ensure that the next Sync Job has completed successfully before attempting the following steps below.



Follow the steps below to change the Connection Details in your current Excel OData reports from BC Web Services to Linc Data Warehouse:


1. From the Power Query Editor, create a new source:



2. Enter the below Server and Database details in the window below, followed by your SQL Username and password as created in BC on the Linc Data Warehouse SQL Users page:


Server:       server-producelincdw.database.windows.net

Database:  LincDW



3. Select the table from the list of tables contained in the Linc Data Warehouse:



4. Replace the existing query's Source with the Source of the newly created query:





5. Add/Insert the Navigation step from the New query to the Original query, immediately following the Source step. Be careful to not delete any following steps in the Original query and to insert the Navigation step directly after the Source step before any other steps of the Original query:






6. Delete the New query and keep the Original query in the report:




7. Close and load the adjusted Original query in the report: