Linking to Sharepoint BUT file I want isn't displayed "the data in the preview has been truncated"

[RedWineGirl]

How do I show more options? The spreadsheet I need to link to doesn't show but is there?

Thanks!

[RedWineGirl]

Think I've fixed my issue, I needed to select Transform Data > then under Content select Binary on the file I wanted. Then select the tab I needed with the data and then I get data! (must remember this for next year). Thank you

[RedWineGirl]

Managed to connect -the spreadsheet I need to connect to isn't on this list,  if I just select Load, I get Query 1 showing with fields Date Heirarchy, Folder Path and name of spreadsheets (mine is listed as a name) but I can't get to the data? ThanksThe spreadsheet isn't on this list

[Anonymous]

Hi @RedWineGirl ，

I have found a similar post, please refer to it to see if it helps you.

Solved: The data in the preview has been truncated due to ... - Microsoft Power BI Community

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 I have misunderstood your meaning, please provide more details with errors, like screenshots.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[RedWineGirl]

Thanks - tried again this morning and now getting Details: "SharePoint: Request failed: The remote server returned an error: (503) Server Unavailable. (Service Unavailable)" so will try later! The issue I had was similar to the example, a but list of spreadsheets with mine not showing, but when I loaded all, the details of the spreadsheet was visible (e.g. size) but not the actual data within the spreadsheet.  Will try and see why I am getting the current error and then send screenprints. Many Thanks

[RedWineGirl]

If I load, this is what I get - so I can see the file name but can't get to the data?