Forum Discussion

TusharGaurav's avatar
TusharGaurav
Helper III
8 months ago
Solved

Not able to refresh a semantic model having excel as a source kept in sharepoint

Hi Experts,   In the power bi report that I developed, I am using a excel file kept at a sharepoint location. I am able to connect to sharepoint from power bi desktop. However when I publish the ...
  • TusharGaurav's avatar
    TusharGaurav
    8 months ago

    Hi Rohit,

    Thanks for your response.

    I was using web connector to connect to the file with url similar to below url:

    https://xxxx.com/:x:/r/sites/xxxx/Shared%20Documents/xxxx/xxxx/abc.xlsx

    However I chnaged the connector type to "SharePoint Folder" and used below URL:

    https://xxxx.com/:x:/r/sites/xxxx/Shared%20Documents/xxxx/xxxx

    But now I am not able to connect from power bi desktop too and getting the below error:

    Details: "Microsoft.Mashup.Engine1.Library.Resources.HttpResource: Request failed:
    OData Version: 3 and 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
    OData Version: 4, Error: The remote server returned an error: (404) Not Found. (Not Found)
    OData Version: 3, Error: The remote server returned an error: (404) Not Found. (Not Found)"

    Please suggest.

     

    Thanks, 

    Tushar