.aspx from sharepoint

[Heinet]

We want to make a report based on data in sharepoint. The data is in a list that as far as I understand i sin a .aspx file and I am unable to get the data into power bi.

To total sharepoint link is like this: https://CompanyName365.sharepoint.com/sites/projectportal/Projectname/SitePages/process.aspx

On this page the project managers fill in a list like this after  opening up "0.1"

I have tried via both sharepoint.list and sharepoint.content but I can't find any way to access the data, I can get properties etc for the .aspx but that is it.

I tried using webpage but it told me it only support anonymus authentication. Is there anyone that is smarter that me out here that see a solution?

Cheers Heinet

[Anonymous · Accepted solution]

Hi @Heinet ,

Power BI doesn't support us to get data from the ASPX files. For reference: Power BI data sources

However, I think Power BI may show you some information about the ASPX file, if you try to connect by Sharepoint Online list connector.

The below code, adding your URL in, will give you a good start.  As time goes on the filter line might require tweaking depending on what changes Microsoft makes, or if you need those elements.

let
    Source = SharePoint.Tables("https://<YourSite>", [ApiVersion = 15]),
    #"Filtered Rows" = Table.SelectRows(Source, each ([Title] <> "appdata" and [Title] <> "appfiles" and [Title] <> "Form Templates" and [Title] <> "List Template Gallery" and [Title] <> "Master Page Gallery" and [Title] <> "Site Assets" and [Title] <> "Solution Gallery" and [Title] <> "Style Library" and [Title] <> "TaxonomyHiddenList" and [Title] <> "Theme Gallery" and [Title] <> "Web Part Gallery"))
in
    #"Filtered Rows"

Here is a solved post with similar requirement like yours. You may refer to it to learn more details.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.