...
Select and filter what data to show in the Power Bi report by selecting or deleting columns and applying required filters (eg: filters.
8. Once you have the required data from Query Editor → Close & Apply
...
OrderNo → Customer → Dispatch_Suburb → Dispatch_Post_Code → Order_Amount_ExTax → Order_Amount_IncTax → Workflow_Dispatch_Status → Workflow_Job_Tracking_Status → Order_status
You can add columns and
With Power BI Desktop installed you’re ready to connect to data, shape data, and build reports (usually in that order).
Further help can be found:
https://docs.microsoft.com/en-us/power-bi/
https://docs.microsoft.com/en-us/power-bi/guided-learning/
Connect Data via Excel
Connecting your data via excel, if you dont already have Power Query you can download here → https://www.microsoft.com/en-au/download/details.aspx?id=39379
...