The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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