Forum Discussion
Run a query against a dataset, create .csv
Hey, ... i didn't get any help in the Power Automate community, so i'll try it here: Whereever i look, this should work for everyone accept me haha. I Just want to get a .csv table out of...
Hi wshalex123,
I think what Imke is suggesting is to import the csv file that you create using the Automation via Power Query in Excel.
on the Data tab in the Excel's main menu.
P.S. Sorry, in your case this is of course would be another connector - Sharepoint Folder - but the idea remains the same.
This way you can then import it from PQ to one of the tabs in the Excel workbook as a table and then just refresh when required.
Cheers,
John
Just giving it another thought: if you still put the data back to Excel, do you want to consider using Analyse in Excel funcionality? This may be a simpler solution, this way you can import data without using Automate and csv as an intermediaries.
Regards,
John