Alteryx to Power BI best file format

[jsouid]

Hello guys !

I was wondering what would be the best format files to export from Alteryx and import to Power BI? I'm using the basic Power BI desktop version. I don't want to export to a file format that include delimiters. I'm looking for a .tde file format equivalent.

Regards,

Jérémie 

[carlosteixeira]

Hi @jsouid 

You do not have a native output in alteryx for PWBI files. But you can use other outputs that PWBI can read as an input.

Like CSV, XML, XLSX ...

Have you tried any of these formats?

[WilliamR]

Bonjour, je vous recommande définitivement d'utiliser un format .csv pou r power bi.

Cdlt.

Si ce post vous aide, merci de le considérer comme solution acceptée afin que d'autres utilisateurs puissent le retrouver plus facilement.

[jsouid]

Hey,

Thank you for your quick reply. The thing is I would like to avoid the Excel file format because of the  lines limit. I would also like to avoid any file format that include delimiters to do not have to deal with it (so the .csv doesn't work for me). That's why I was looking for a .tde file format equivalent. Do you know any file format that could check all these requirement ?

Regards,

Jérémie

[StephV]

Merci @jsouid pour ta question et ton retour ! Je suis sûre qu’elle aidera d’autres utilisateurs. Ce forum est en langue française, ainsi je t'invite à écrire de préférence en français.

Si tu préfères l’anglais, aucun problème, tu peux poster ta question sur le Forum anglais. Merci à toi !

Si les réponses de @WilliamR et @carlosteixeira t'ont aidé, n'hésites pas à les "Accepter comme solution", elles aideront d'autres utilisateurs ;-)​​​​​​​

[VojtechT]

Hi @jsouid ,

the PBI analogy for tde file could be pbix file, but Alteryx Designer is not able to create such file. Not sure if any other SW besides the one by MSFT could do that. 

If you have access to Power BI cloud, you can export the dataset there using the Power BI Output tool and then consume the dataset in your Power BI Desktop. But this might create a huge bandwidth bottle neck.