Forum Discussion
Helper IHow to convert sharepoint list to excel file
when there is a excel file in sharepoint list, we use web as the data source type and give the url of the excel file to extract data from excel.
But when sql analysis project, there is not web data source type.
there is a sharepoint list data source type.
so i can get the sharepoint list where there is the excel file.
But how can i convert the list to the actual excel file?
the picture below is the sharepoint list, in which the first line is the actually the excel file.
YonghunLee
If you already have an AS project, instead of connect the original sharepoint datasource, you can just import the AS model into power bi, you should able to see the data in actual table format in Query Editor.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
2 Replies
- mwegener
Most Valuable Professional
Hi YonghunLee
have you tried copying the M code from Power BI to SSAS Tabular?
In Power BI, files are imported from SharePoint with the "SharePoint folder" connector and not with the "SharePoint list" connector.They seem to be different connectors, whereas in SSAS Tabular the "SharePoint folder" connector is not available.
YonghunLee
If you already have an AS project, instead of connect the original sharepoint datasource, you can just import the AS model into power bi, you should able to see the data in actual table format in Query Editor.Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
