Custom list in SharePoint On Premise Sites (Team Sites,Communication sites etc ) is support Export to Power BI?

adil 1,306

I created some custom lists in Team Site in SharePoint 2019 and created list items with custom columns, is this custom list can be possible to Export to Power BI site?

Xyza Xue_MSFT 25,546 Reputation points Microsoft Vendor

2024-10-31T02:58:32.9533333+00:00

Thank you for your question.

We are currently looking into this issue and will give you an update as soon as possible.

Thank you for your understanding and support.

1 answer

Xyza Xue_MSFT 25,546 Reputation points Microsoft Vendor

2024-10-31T08:03:12.73+00:00
Hi @adil ,

Yes, it is possible to export custom lists from SharePoint 2019 to Power BI. Here are the steps you can follow:

Export to Excel: First, you can export your SharePoint list to Excel. This feature is available in SharePoint 2019 and does not require additional configuration.

Import to Power BI: Once you have your data in Excel, you can import it into Power BI.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Please sign in to rate this answer.
adil 1,306 Reputation points

2024-10-31T11:52:27.5466667+00:00

Hi, thanks for your reply, is any other option available from SharePoint export list items

to Power BI Data source SQL Server database

Xyza Xue_MSFT 25,546 Reputation points Microsoft Vendor

2024-11-04T01:39:30.9966667+00:00

Hi @adil ,

Unfortunately, as far as I know, there is no other way, in SharePoint 2019 all must be exported to excel first.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Custom list in SharePoint On Premise Sites (Team Sites,Communication sites etc ) is support Export to Power BI?

1 answer

Your answer