What is the best file type to import data into Power BI?

Question

I have the opportunity to put data into Power BI in pretty much any file type- which one is best?

I ask because I know that with Tableau, .hyper is the preferred way. Is there a similar file type in Power BI?

Thanks!

Answer 1

Hi,

Q&A currently supports the products listed in right-hand pane (more to be added later on)

You can reach the experts in the dedicated PowerBI forum over here: https://community.powerbi.com/t5/Forums/ct-p/PBI_Comm_Forums

(please don't forget to mark helpful replies as answer)

Best regards,
Leon

Answer 2

Excel can be a good candidate :
-The type of the columns can be understood from power bi.

• Size is 50 % smaller than CSV.
  I am still looking for a better answer though.