Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi All,
I was able to connect to the Sharepoint site by using the connector Sharepoint Online List. When i loaded the data according to some documents the column type should be binary but it showing NULL can someone please advice. Please see the attached screen shot. I want to load th data from the .xlsx file.
Solved! Go to Solution.
Hi @Anonymous ,
There are two workarounds. Please check:
#Ⅰ Use "SharePoint Folder" connector like what @mahoneypat mentioned.
1. Connect to the online SharePoint site.
2. Click "Transform Data".
3. Filter "Folder Path" column to specify one or more document libraries if needed.
4. Filter "Extension" column to specify one or more file types.
5. Combine files.
6. Choose the first file and click OK.
7. Expand "Data" column to get file data.
#Ⅱ Create a blank query and use "SharePoint.Contents" function like what @jairoaol mentioned.
1. Create a blank query.
2. Paste this:
let
Source = SharePoint.Contents("https://xxx.sharepoint.com/sites/xxx/")
in
Source
3. Choose the table you needed in "Content" column.
4. Repeat step 4 to step 7 of workaround #Ⅰ.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
There are two workarounds. Please check:
#Ⅰ Use "SharePoint Folder" connector like what @mahoneypat mentioned.
1. Connect to the online SharePoint site.
2. Click "Transform Data".
3. Filter "Folder Path" column to specify one or more document libraries if needed.
4. Filter "Extension" column to specify one or more file types.
5. Combine files.
6. Choose the first file and click OK.
7. Expand "Data" column to get file data.
#Ⅱ Create a blank query and use "SharePoint.Contents" function like what @jairoaol mentioned.
1. Create a blank query.
2. Paste this:
let
Source = SharePoint.Contents("https://xxx.sharepoint.com/sites/xxx/")
in
Source
3. Choose the table you needed in "Content" column.
4. Repeat step 4 to step 7 of workaround #Ⅰ.
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
switches to SharePoint.Contents this first part of the M code
Source = SharePoint.Tables("https://comos.sharepoint.com/sites/PowerBI/", [Implementation="2.0", ViewMode="Default"]),
If you are looking to connect to files, you should use the SharePoint Folder connector, not the list one. You can switch to that connector or change your Source line to use SharePoint.Files or SharePoint.Contents, instead of SharePoint.Tables.
Pat
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
@mahoneypat thanks . This is not our network , it is an online sharepoint site.
Thanks
The problem is still the same. You are trying to use a SharePoint list connector to connect to a SharePoint file. If you want to connect to a SharePoint file, you must use the appropriate (different) connector, as @mahoneypat pointed out.
What does your query M code look like?
@AlexisOlson thanks
let
Source = SharePoint.Tables("https://comos.sharepoint.com/sites/PowerBI/", [Implementation="2.0", ViewMode="Default"]),
#"cd5eed38-9a7a-441c-b706-aa952a8aef2d" = Source{[Id="cd5eed38-9a7a-441c-b706-aa952a8aef2d"]}[Items],
#"Sorted Rows" = Table.Sort(#"cd5eed38-9a7a-441c-b706-aa952a8aef2d",{{"Modified", Order.Descending}})
in
#"Sorted Rows"
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the February 2025 Power BI update to learn about new features.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
83 | |
69 | |
68 | |
39 | |
37 |