The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Get SharePoint List/Library Using OData Feed
Steps
Note
In case the current user is not authorized to connect to the site, you will be prompted to set the right credential as shown below.
Get SharePoint List/Library Using SharePoint List Connection
Steps
Hi. My report in Power Bi gets the data from a list in SharePoint. Works fine. But what if I cannot add new data to the list in SharePoint? Instead I have a new list with the new data and I need my report in Power Bi to drop the first list and use the new list to get the new data. How can I switch lists in a Power Bi report?
Of course, for obvious reasons changing names of lists in SharePoint doesn't work.
Thanks.
just to make sure, when you get data from a list, any alterations you do to the data will not be reflected on the list, right?
Wondering if the community can help me out.
I am able to connect my PowerBi to a SQL server and pull live data from the source. I am looking to get that live data to show as a "living" Excel doc that I can host or make a SharePoint list to connect the data to other applications we use internally at my company.
A lot of people want to know who to connect power BI to a SharePoint list but I am looking to do the reverse, connect a list to a Power BI data set. Is this possible?
You can try to use Power Automate for this functionality. You'd also need bulk delete or a delete duplicates added to the list as well flow. The flow can be a scheduled to run every second (or the time it takes for the flow to run - whichever is larger).
Excellent, thank you.
Works a treat.
Jason