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 followin...
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).

      • taate29's avatar
        taate29
        Helper I
        5 years ago

        edhans Do you know where I can see the settings of this sharepoint site?

         

        This problem doesn't happen when I try to link a direct file from my computer. This is happening only when I use the sharepoint folder connector. Unfortunately I don't have another choice, because I need to upload it in an app and this folder has a lot of similar archives that I need to put together.

         

        My current version of Power BI is Versão: 2.84.802.0 64-bit.