Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Can't connect / refresh using external SharePoint site

I'm trying to connect to a SharePoint site (not my own company's - a company has provided a username/password for me to connect).   In Power BI Desktop I connect via the SharePoint folder method, b...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

HiAnonymous，

 

Please check if the filename contains certain special characters, it may lead to authentication errors due to the filename being truncated in the URL. If you are getting unusual authentication errors, make sure that all of the filenames you're using don't contain any of the following special characters.

# % $

If these characters are present in the filename, the file owner must rename the file so that it does NOT contain any of these characters.

 

Hope it helps.

 

Best Regards,

Caitlyn Yan

 

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

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi CaitlynV ,

 

The filenames don't contain any strange characters. In Power Bi Desktop we can successfully connect to the SharePoint folder - see all the files that are visible, filter it to the relevant files (all spreadsheets), expand their contents and trasnform the relevant columns. It is only when we publish this to Power BI Service that it becomes a problem.

 

In Power Bi Desktop, the first couple of steps in query editor are:

= SharePoint.Files("https://portal.xxxx.com/sites/xxxx/", [ApiVersion = 15])
= Table.SelectRows(Source, each [Date created] > #datetime(2021, 1, 1, 0, 0, 0))