Forum Discussion
PowerBI dataflow to SharePoint
Hello - was wondering if there was an easy way to get data from PowerBI into SharePoint. PowerBI houses spend data loaded from our accounting systems. I've created a table in PowerBI that includes the name of the vendor, previous year total spend, and curreny YTD spend. In SharePoint, I have the same list of vendors, and I would like the spend amount to flow into the SharePoint List. Only a few people have access to the data in PowerBI which is why I need to extract it into SharePoint. Does anyone have any ideas on how I can accomplish this?
2 Replies
Anonymous , Not very clear to me. Are looking for this
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-embed-report-spo
Hi amitchandak No I don't want a report I would like the data to flow to it's "item". For example if I have a list that looks like the table below and the same table in PowerBI. Is there a way to make the data flow from the table in PowerBI into SharePoint the corresponding list item? There are about 1,000 line items. The SharePoint list has lots of other columns as well but just need to pull the spend amounts in. The 2021 spend would be a onetime job but the ytd spend would need to update weekly or even daily if possible.
Company Name Spend 2021 Spend YTD Company A Company B
