How to get data from Sharepoint(.aspx) lists into PowerBI

[VikasMattela]

Hey I need help on below error,

I would like to get data from sharepoint lists from sharepoint aspx page into PowerBI.

I have used Web,SharePoint Online Lists,SharePoint List but none of the options are working out.

Getting Script Error While connecting through Web.

https://mysharepointsitename/Lists/Registration/AllItems.aspx

To access web content used Organizational Account.

[VikasMattela]

Hi. Thanks for the reply. I have sent an email to clinet to get the credentials to access the sharepoint

[v-yalanwu-msft]

Hi, @VikasMattela ;

Find the address (also known as a URL) of your SharePoint Online site that contains your list. From a page in SharePoint Online, you can usually get the site address by selecting Home in the navigation pane, or the icon for the site at the top, then copying the address from your web browser's address bar.like below:

Create a report on a SharePoint List in Power BI Desktop - Power BI | Microsoft Learn

Please refer to this article.

Get Excel Data from a Single File or Entire Folder on SharePoint or OneDrive for Business into Power...

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.