search

microsoft / sql-server-samples

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge
Other
10.08k stars 8.9k forks source link

WorldwideImportes - DB Backups not Matching the Power BI Dashboards #1316

Open Thokar opened 4 months ago

Thokar commented 4 months ago

I have restored the WorldwideImportes and WorldwideImportesDW and and Imported the WWIDW-Sales and WWI-SalesOrders

The WWI-SalesOrders for WideWorldImporters is missing the Object Website.SalesOrders: The Query:

[Query="SELECT SO.OrderID, OrderDate, OrderNumber, CustomerName, DeliveryLocation, SalesPerson, SUM(Quantity * UnitPrice) AS OrderPrice #(lf)FROM Website.SalesOrders SO JOIN Website.SalesOrderLines SOL ON SO.OrderID=SOL.OrderID#(lf)WHERE OrderDate >= DATEADD(day, -1, CAST(SYSDATETIME() AS date))#(lf)GROUP BY SO.OrderID, OrderDate, OrderNumber, CustomerName, DeliveryLocation, SalesPerson#(lf)#(lf)"])

What am i missing?