Before you did the refresh, you deleted the top and bottom rows. Your power query script already had those steps, couldn't it have taken care of the deletion?
Yes the PowerQuery took care of the removing the top and bottom rows. I think I must have been explaining from the Excel file that is was we wanted to do. The data source was Excel which I think I was trying to explain it again which may have seemed redundant.
Thank you for the video Steve. But I was looking for some way to link directly to Power Query. Do you think there is a possibility?
I'm also looking for the same. Did you find it?
Nice job. Thanks for the video.
Before you did the refresh, you deleted the top and bottom rows. Your power query script already had those steps, couldn't it have taken care of the deletion?
Yes the PowerQuery took care of the removing the top and bottom rows. I think I must have been explaining from the Excel file that is was we wanted to do. The data source was Excel which I think I was trying to explain it again which may have seemed redundant.
Would this be the same process if i want to export invoices with products and goods sold?
Would this be the same process to export sales and group by products and goods sold?
Maybe. Whenever the report has groupings built in it is not as straight as a table format.