Forum Discussion

AAJahfali's avatar
AAJahfali
New Member
3 years ago
Solved

combining excel files from share point

I could not combine files in power query for excel files available in SharePoint, which were exported by the Microsoft project. Even if I tried to open them by an individual without combining them th...
Need Help
  • AAJahfali's avatar
    AAJahfali
    3 years ago

    The Problem Solved 🎉

     

     

    in the first, the files' names contained "#" 

    so I deleted the "#" sign then the power query accepted to combine the files together

    I feel I wanna cry

jbwtp's avatar
jbwtp
Memorable Member
3 years ago

Hi AAJahfali,

 

This is quite interesting.

Why are you opening them as Web.Content (Web connector). Why not using Sharepoint Folder connector? I think this is why they fail to open. Do you mind also sharing your code (at least the first couple of lines where you call the connector to fetch the data)? Maybe remove the address part for security.

 

Cheers,

John

AAJahfali's avatar
AAJahfali
New Member
3 years ago

I am using SharePoint Folder 

now I tried to export from the project manager a different type "CVS" and connect it to the power query by SharePoint Folder service and still getting the same problem when I click combine the process it will not appear and when I try to open it individually then this message will come to me 

DataFormat.Error: The input URL is invalid. Please provide a URL to the file path on SharePoint up to the file name only (with no query or fragment part).
Details:
    https://seccomsa.sharepoint.com/sites/WesternRegionTIReport-M.SProjectUsers/Shared Documents/M.S Project Users/New folder/Unit#11 Annual Inspection Updated.csv

 

let
    Source = SharePoint.Files("https://seccomsa.sharepoint.com/sites/WesternRegionTIReport-M.SProjectUsers/", [ApiVersion = 15]),
    #"Filtered Rows" = Table.SelectRows(Source, each [Extension] = ".csv"),
    next = #"Filtered Rows"{[Name="Unit#11 Annual Inspection Updated.csv",#"Folder Path"="https://seccomsa.sharepoint.com/sites/WesternRegionTIReport-M.SProjectUsers/Shared Documents/M.S Project Users/New folder/"]}[Content]
in
    next

 

This is the Code