Export Power BI data to a SharePoint list

[@CurbalEN]

Here is how you rename columns in Power Automate:
ruclips.net/video/lWu4n-ODe4U/видео.html&ab_channel=Curbal

[@hmvrocks]

Great Thank you. Your content is helpful.And thanks for replying.😇

[@kazan1723]

There is literally nobody else in this world right now that I love as much as I love you, Thanks for the continual rescue effort to all of us

[@halmi358]

Thanks for your videos, they are very helpful! Following your tutorial, I exported a Powerbi report into a Sharpoint list using Power Automate.
Unfortunately he always appends the records. Maybe you could show how an update works?
It would be nice to have a list on the Sharepoint that corresponds 1:1 to the report in the Powerbi

[@Xanta-k7q]

How are you able to select a specific output [Sales] from your 'Run a query against a data set'? I only have the standard options of First Table Rows, Body, and Rows.

[@gabriellevaz9842]

Same here. I think it's a new update. If you have any solutions please share with us 😢

[@CurbalEN]

Here is how you rename columns in Power Automate:
ruclips.net/video/lWu4n-ODe4U/видео.html&ab_channel=Curbal

[@CurbalEN]

@@gabriellevaz9842 Here is how you rename columns in Power Automate:
ruclips.net/video/lWu4n-ODe4U/видео.html&ab_channel=Curbal

[@ChrisCarlsonAntonio]

This video was a life saver. Thank you! Also I had a heck of a time because my table formula kept spitting out a blank row at the bottom. Copilot kept giving me bad formulas and the help said to use data query instead. Ultimately here's the formula structure that removed the blank row(s) in case anyone needs it.
Table =
VAR FilteredTable =
FILTER(
Partner_Reporting,
NOT ISBLANK([OppID]) &&
NOT ISBLANK([Amount]) &&
NOT ISBLANK([Category]) &&
NOT ISBLANK([Bonus])
)
RETURN
SUMMARIZE(
FilteredTable,
Partner_Reporting[OppID],
Partner_Reporting[Amount],
Partner_Reporting[Category],
Partner_Reporting[Bonus]
)

[@jonaskarlsson477]

i dont get the option to choise the values from powerbi dax in the select

[@gabriellevaz9842]

If you have any solutions please share with us. I'm kinda desperate 😅

[@rpremaza]

Thank you...
Question. In my PowerBI datasource i have a column call Reference ID Its a unique key. How to check (and skip) any record where the Reference ID is already in the SharePoint list?

[@Tech2188]

you might have to setup a query to the SharePoint list and then filter after the select with a "where not in" list from SharePoint type of filter.

[@andrewfoncette5231]

Also, how do I automate only recently added Power BI data to the SharePoint List?
At the moment my automated workflow is automating my current list of Power BI data over again including the recently added data.

[@arunv1909]

😇 i been looking for this video , thanks

[@saurabhsharma-yh7fu]

Thank you this flow is working fine🎉

[@CurbalEN]

🥳

[@SharedMFamily]

This is awesome, thank you.

[@hmvrocks]

@curbal - Even i have same issue - I only have the standard options of First Table Rows, Body, and Rows. Can you please help how did you got [sales]?

[@CurbalEN]

Here is how you rename columns in Power Automate:
ruclips.net/video/lWu4n-ODe4U/видео.html&ab_channel=Curbal

[@mpikers]

Is there a way to insert new and update based on a match key?

[@sebastianmamiak6823]

That's great, but what if I only want to add new items to the sharepoint list? How do I avoid duplication?

[@CurbalEN]

You append instead of create. Check the export playlist, it has a tutorial on append in excel, it might be similar.

[@cristianprifti]

Hahaha, funny enough just did such a variation this morning but from inside power bi 😅 like selecting some dimensional values from a slicer, which get written in the sp list after click

[@CurbalEN]

You inspired me!

[@cristianprifti]

@@CurbalEN that is a first, from being normally the other way around 🤣

[@jonathanheath8903]

Thank you for sharing your insight ! On how to adjust if you need to create list of list inside of SharePoint with file attachment also

[@CurbalEN]

😂

[@cristianprifti]

@@jonathanheath8903 you can achieve the upload of attachments, but as far as i know, there is no way to have lists within lists, with the exception of the lookup columns which will link together lists elements.

[@hamishmaxa6509]

The 2 dates with no sales in the Output look invalid?

[@CurbalEN]

I mention it in the video, there where no sales those dates.

[@mosunmolaoyeleye1097]

how did you rename the columns

[@CurbalEN]

Here is how you rename columns in Power Automate:
ruclips.net/video/lWu4n-ODe4U/видео.html&ab_channel=Curbal

[@karanchauhan2728]

I have the following data
Home Coffee Office Coffee On-the-go Coffee Cafe Coffee None of these No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer No Answer YES YES YES YES NO NO NO NO YES NO No Answer No Answer No Answer No Answer No Answer YES YES YES YES NO NO
i want to show the count of each in one chart by using slicer(single select)of the column names, in other words on x axis should be Yes No and no answer and y axis the count of it. how should i do that in power bi ?🤔