Retrieve data by referencing a table within my Power BI File

[Anonymous]

Hi team,

I have a working excel based power query which helps me retrieve list of all sharepoint url's, this is then saved as a table. This table thereafter is used as a reference to retrieve list of all contents from every sharepoint URL in the table. Now, I'm trying to use the same logic to retrieve data using Power BI. However, I do not know what is the expression to reference a table within PowerBI. Following is the manner in which I reference presently

Sites= Excel.CurrentWorkbook(){[Name="Projects"]}[Content]

Any ideas / suggestions will be helpful here.

Kind regards,

A!

[v-sihou-msft]

@Anonymous

Currently, there's no Data Access function for Power BI file. You have to directly rertrieve the data from SharePoint List. For more details, please see: Accessing data functions.

Regards,