What file type do you use to export large data set from Alteryx to PowerBI?

[vball]

I am currently using Excel but Excel does not like huge datasets (over 250K rows) and has error message. (The error message does not seem to cause the data to be inaccurate. It is just annoying.)

I also tried csv and json but both file types have numerous error messages in Alteryx, which seems to be because the dataset I have include a lot of string characters like comma. Therefore, Excel is better than those two.

Is there another file type you'd recommend?

I don't plan to use the PowerBI Rest API as the documentation on it said it has a lot of limitations like maximum rows and performance time. 

Thank you.

[gautiergodard]

Have you tried the SQLite file option?

This should work for your use case.

[Felipe_Ribeir0 · Accepted solution]

Hi @vball 

1) It is expected,  XLSX is a actually a compressed (zipped) file. - excel - *.csv Increase the file size - Stack Overflow

2)Take a look at your output and try to input it on pbi. If you have any error, you can try to use the data cleansing tool. Here some explanation about why Solved: Warning message: Newlines detected - Alteryx Community

3)If you set the encoding of your output to UTF-8 and configure the input of your pbi to UTF-8, i would not expect problems. 

[vball]

@gautiergodard Thank you but that would not work for us as other users will need to consume the data in Microsoft Office in addition to the need to upload to Power BI. Sorry, I should have made my request clearer.