question

ColeStauss-8359 avatar image
0 Votes"
ColeStauss-8359 asked GregoryWALLACE-8394 answered

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

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!

not-supported
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

2 Answers

LeonLaude avatar image
1 Vote"
LeonLaude answered AvnishKumar-1203 published

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

· 2
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

DSPatrick avatar image DSPatrick ·

That's brilliant! How original!

1 Vote 1 ·
AvnishKumar-1203 avatar image AvnishKumar-1203 ·

Hi Leon, Could you please share the direct link or let us know here. I think the answer is not available on the page.

1 Vote 1 ·
GregoryWALLACE-8394 avatar image
0 Votes"
GregoryWALLACE-8394 answered

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.

5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.