Forum Discussion

wshalex123's avatar
wshalex123
Icon for Helper III rankHelper III
3 years ago

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...
Need Help
jbwtp's avatar
jbwtp
Icon for Memorable Member rankMemorable Member
3 years ago

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

jbwtp's avatar
jbwtp
Icon for Memorable Member rankMemorable Member
3 years ago

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