enter image description here
Hello everyone, you will find in my image a Power Automate flow with the creation of a CSV from a Power BI dataset. Everything works very well except for one small detail. Indeed, I would like to have separated columns in my CSV. I don't understand why it doesn't work. Some might suggest using 'run a script' to convert my CSV in my Excel file, but the problem is that as soon as I have more than 30,000 lines to transform, my script no longer works! If anyone can come to my rescue, thank you very much
enter image description here
Hello everyone, you will find in my image a Power Automate flow with the creation of a CSV from a Power BI dataset. Everything works very well except for one small detail. Indeed, I would like to have separated columns in my CSV. I don't understand why it doesn't work. Some might suggest using 'run a script' to convert my CSV in my Excel file, but the problem is that as soon as I have more than 30,000 lines to transform, my script no longer works! If anyone can come to my rescue, thank you very much
Share Improve this question asked Mar 18 at 16:33 user25891342user25891342 11 bronze badge 1- Show us an desired output so we can understand what you mean. As of right now, I’m not sure what you’re exactly asking for. – Skin Commented Mar 18 at 20:12
2 Answers
Reset to default 0I'm unsure what you're trying to do in your compose, but could you not go from your PowerBI direcly (skipping compose) to "create csv table" and then save the results to sharepoint?
Csv starts with a header row and then continues with data for each line, so out of the box it should do what you need. - The delimiters can be different depending on region (I've seen many csv's (Comma Seperated Values) that are semicolon separated, so that might also be your issue.
Perhaps you should show us a bit of your dataset... as in
Current state => desired state
so that we have an idea of what transformation you want to achieve here, more details please.
By default, CSV files store table data in text format and does not support columns.
You need a tool like Excel text to column function to do it. But if you convert it using Excel, you'll need to save if as a Excel file, since CSV does not support columns.
And a power BI visual limits to 30,000 lines during export.
Maybe you can try fractioning the data.