Forum Discussion

YonghunLee's avatar
YonghunLee
Icon for Helper I rankHelper I
4 years ago
Solved

How 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 d...
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    4 years ago

    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.

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

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.

 

https://docs.microsoft.com/en-us/analysis-services/tabular-models/data-sources-supported-ssas-tabular-1400?view=asallproducts-allversions