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.

      • edhans's avatar
        edhans
        Community Champion
        5 years ago

        I don't know what you mean by direct file link.

        Did you try to connect in Excel?

        Your Desktop is a few weeks old. I think that is August 2020, but not the latest. Download the latest and try again. Hopefully it is that simple.

        As for SharePoint settings, no idea. I am not a SP expert by any means and know little beyond basic permission settings. You'd need a SP expert to assist. The MS tech community here would have SP gurus, and this one is specifically on SharePoint BI.