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.

[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

[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