Forum Discussion

taate29's avatar
taate29
Helper I
5 years ago

Update Error - [DataSource.Error] Sharepoint: Request Failed

Hey guys!

 

I have a Power BI Desktop file that I created a few months ago. I connected it using Sharepoint folder and everything had worked fine until last week. When I try to update, the following message appears:

 

"[DataSource.Error] Request Failed: [URL]"

 

 

 

I saw many posts about this issue and I tried to apply all the possible solutions:

* I updated my Power BI to the last version (Aug 2020);

* I changed all my data to connect using Sharepoint Folders;

* I changed the credentials to Level of privacy: None.

 

Somebody had the same problem before and found some other solution?

I have been trying to solve this for a long time, without no sucess.

 

Thank you in advance,

 

8 Replies

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    taate29 - can you see if you can make a new connection to the SharePoint site? Also, can you post your source command from the original query - it is the first line in your M code (after the let statement) in the advanced editor. You can remove your tenant name of course.

    • taate29's avatar
      taate29
      Helper I
      5 years ago

      Hi edhans!

       

      I tried to do the same connection in a blank pbix file and I got the same error.

      The code line follows bellow:

       

       Fonte = SharePoint.Files("https://xxxx.sharepoint.com/teams/Sharepointname", [ApiVersion = 15]),
    #"Linhas Filtradas" = Table.SelectRows(Fonte, each ([Folder Path] = "https://xxxxxx.sharepoint.com/teams/folderpathdirectly/")),
    #"Arquivos Ocultos Filtrados1" = Table.SelectRows(#"Linhas Filtradas", each [Attributes]?[Hidden]? <> true),
    #"Invocar Função Personalizada1" = Table.AddColumn(#"Arquivos Ocultos Filtrados1", "Transformar Arquivo (8)", each #"Transformar Arquivo (8)"([Content])),
    #"Outras Colunas Removidas1" = Table.SelectColumns( #"Invocar Função Personalizada1", {"Name", "Transformar Arquivo (8)"}),
    #"Coluna de Tabela Expandida1" = Table.ExpandTableColumn(#"Outras Colunas Removidas1", "Transformar Arquivo (8)", Table.ColumnNames(#"Transformar Arquivo (8)"(#"Arquivo de Amostra (8)")))
in
    #"Coluna de Tabela Expandida1"

       

      My code is in portuguese, so let me know in case of doubt.

      Thank you!!

       

      • edhans's avatar
        edhans
        Community Champion
        5 years ago

        Can you connect to a different SharePoint site?
        I am wondering if someone has changed permissions or settings on that SharePoint site not realizing it could cause issues with Power BI.

         

        For grins, try connecting to that same site with Excel via Get Data. This will rule out a Power BI specific bug, but I connected to a SharePoint site yesterday with yesterday's Power BI desktop build for August 2020 (it is the 4th or 5th mini-release this month).