Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
You have to select the check box on the right side to enable it for you
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.
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
I have the same problem
You need to click the ceck box of a table then only the load buttion visible
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...!!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
78 | |
75 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |