Export Power BI data to a SharePoint list

Scroll down for all the tutorials on expot data:

Join this channel membership to get access to all the recorded bites as they become available:

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen

#CURBAL #SUBSCRIBE

[CurbalEN]

Here is how you rename columns in Power Automate:

[kazan]

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

[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]
)

[arunv]

😇 i been looking for this video, thanks

[halmi]

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

[alexanderdoan]

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.

[mpikers]

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

[jonaskarlsson]

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

[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?

[sebastianmamiak]

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

[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

[hemalvachani]

@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]?

[hamishmaxa]

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

[karanchauhan]

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 ?🤔