Forum Discussion
Run a query against a dataset, create .csv
Hi wshalex123 ,
csv is a comma separated text format, so the result looks as expected to me.
When openening it in Excel, you can split it by this delimiter: Go to DAta -> Data Tools -> Text to Columns
and then choose the comma as a separator.
Or open it via Power Query, that's a bit more reliable.
Hey ImkeF,
thanks you for your response.
Iam deleting this file once per day and save it again there via this flow, so a Solution in Power querry would be fitting more in my case.
Can you help me with this? 🙂 Or do you have any other idea how i could automattically export the table from Power BI in another table or make in change it in one?
Thanks a lot.
Cheers, Alex
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
