Export Power BI data to a SharePoint list

Scroll down for all the tutorials on expot data:
curbal.com/curbal-learning-po...
Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @[e-mail]
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE

[@CurbalEN]

Here is how you rename columns in Power Automate: kzbin.info/www/bejne/oojYZaFjhKmYarc&ab_channel=Curbal

[@hemalvachani3723]

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

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

[@SharedMFamily]

This is awesome, thank you.

[@arunv1909]

😇 i been looking for this video , thanks

[@saurabhsharma-yh7fu]

Thank you this flow is working fine🎉

[@CurbalEN]

🥳

[@alexanderdoan5757]

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: kzbin.info/www/bejne/oojYZaFjhKmYarc&ab_channel=Curbal

[@CurbalEN]

@@gabriellevaz9842 Here is how you rename columns in Power Automate: kzbin.info/www/bejne/oojYZaFjhKmYarc&ab_channel=Curbal

[@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 😅

[@mpikers]

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

[@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.

[@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.

[@hemalvachani3723]

@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: kzbin.info/www/bejne/oojYZaFjhKmYarc&ab_channel=Curbal

[@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.

[@mosunmolaoyeleye1097]

how did you rename the columns

[@CurbalEN]

Here is how you rename columns in Power Automate: kzbin.info/www/bejne/oojYZaFjhKmYarc&ab_channel=Curbal

[@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.

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