Exporting Custom Columns to SharePoint

[Mario69]

I have a Power BI report that I'm currently working on.  Is there a way to export custom columns in Power BI added using Transform Data to SharePoint?  

[Anonymous · Accepted solution]

Hi @Mario69 ,

If I understand you correctly, you should have first connected to Power BI Desktop using sharepoint as a data source, then created the Custom Column in Power Query, and now you want the Custom Column you created to exist inside the data source in sharepoint as well.
You can try these ways:

First, export the data with the custom columns from Power BI to an Excel file. You can do this by using the 'Export data' option from a visual that includes your custom columns. Once you have the Excel file, you can import this file into SharePoint. SharePoint has a feature that allows you to create a list from an Excel file.
Create a SharePoint list from Microsoft Excel

Or you can republish the converted data and report to Power BI Service and then embed the report in Sharepiont using the URL.
Embed a report web part in SharePoint Online - Power BI | Microsoft Learn

Or, you can try to use Power Automate to create a flow that takes the data from Power BI and creates or updates items in a SharePoint list. This method is more dynamic and can be automated to run on a schedule or triggered by specific events.
Get started with Power Automate - Power Automate | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

transform to what exactly?  a file a list ?

power bi does not transform to sharepoint, it can be embedded in sharepoint to show a pbi dashboard, but if you wanting it to publish data to sharepoint, it only publishes to the power bi service,   which can be embeded in sharepoint.