Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
We are setting up an image bank in Sharepoint. We would like to add an ID column to our picture tags that could act as a lookup column for data stored in a power bi dataset. We are having trouble finding the best way to create a Sharepoint List from our Power BI Dataset in order to create the returning lookup column.
Hi @jburklund
You can't use Power BI dataset data directly to Sharepoint.
Export your data from Power BI dataset, may be using export data on visual option and key it in excel format.
From excel, you can push your data to Sharepoint either directly or using Power Automate.
https://www.beyondintranet.com/blog/how-to-export-and-import-excel-to-a-sharepoint-list/
Power Automate - https://www.c-sharpcorner.com/article/copying-data-from-online-excel-to-sharepoint-list-using-power-...
Thanks
Hari