The data in the preview has been truncated due to size limits.

[benidoink]

Hi Guys,

I tried to connect my excel to Power BI desktop, What I do is go to "Get Data' then I click Web > copy the Path in Sharepoint site > click ok. But unfortunately I encounter error. It said "The data in the preview has been truncated due to size limits."
I appreciate your response. Thank you.

[Syndicate_Admin]

You have to select the check box on the right side to enable it for you

[benidoink]

Hi @selimovd ,

It's working with complete data. Thank you.

[selimovd · Accepted solution]

Hey @benidoink ,

you don't have to worry about that. This just means you only see the first 200 rows in this window and not all rows.

Once you really load the data everything will be loaded.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Rajimariam21]

Please I did as you said, load the data yet it won't work. The data was loaded as code which isn't suppose to be so. I tried loading a different csv file from sql. It didn't work too. Have been struggling with this for 2 days now. Please if I can get a response, i'd appreciate.

[Syndicate_Admin]

Cordial greetings, at the time of importing a database I get the same message but it does not show me the database as such, it does not let me do anything

[Syndicate_Admin]

Hello, I take advantage of this thread that already existed because I have an almost identical problem.

It also returns the same message "Preview data has been truncated due to size limits."

However, unlike the original post of this thread, the "Load" button is not enabled for me, that is, they are all shaded and I can not move forward: attached screenshot.

I sincerely appreciate any help to be able to unlock me.

Thank you

[cyates83]

I have the same problem

[Veera12]

You need to click the ceck box of a table then only the load buttion visible

[Rajimariam21]

which check bok of a table please?

[Syndicate_Admin]

I'm trying to connect to Sharepoint folders, only a few files appear, I have several folders containing excel files.

I look forward to your support. Thank you...!!

only a few files appear, I have several folders containing files