Forum Discussion
Opening an Excel Spreadsheet from a SharePoint site?
Thanks for that Amit,
The first option did not work, as unlike the OneDrive, it never asked for credentials, so just gave me this:
The next interesting post is Curbal's video, but it appears her video is so old that the process has changed in BI and I cannot change Tables to files, as she does, but I do get a list of tables, but donot have any way of switching to files, as I am still stuck in the wizard, and not in the editor as she is.
The last link does not help, because if you keep the folder "sites" after your sharepoint address, it gives the error you get if you don't strip the rest of the path out.
I would love the top one to work, but I just don't get asked for credentials.
Really frustrating now.
But thanks for your answer and all the links.
I have discovered the issue. Amit solution works in the default Desktop version of Power BI, but I was trying to build this in the Reporting Server version with the black icon, which was last updated in May 2020, and it fails with this version. So I have started building it in Standard Desktop, then saved it, and tried to open it with Desktop RS and it is not compatable. So the question to be answered now is if it is just the case of Desktop RS needs a revision, or can I simply not add spreadsheet from Sharepoint at all in Reporting Server?