Export Power BI data to a SharePoint list
Вставка
- Опубліковано 6 бер 2024
- 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 ► @ruthpozuelo@techhub.social
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
Here is how you rename columns in Power Automate:
ua-cam.com/video/lWu4n-ODe4U/v-deo.html&ab_channel=Curbal
Great Thank you. Your content is helpful.And thanks for replying.😇
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]
)
😇 i been looking for this video , thanks
This is awesome, thank you.
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.
Same here. I think it's a new update. If you have any solutions please share with us 😢
Here is how you rename columns in Power Automate:
ua-cam.com/video/lWu4n-ODe4U/v-deo.html&ab_channel=Curbal
@@gabriellevaz9842 Here is how you rename columns in Power Automate:
ua-cam.com/video/lWu4n-ODe4U/v-deo.html&ab_channel=Curbal
Thank you this flow is working fine🎉
🥳
i dont get the option to choise the values from powerbi dax in the select
If you have any solutions please share with us. I'm kinda desperate 😅
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?
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.
Is there a way to insert new and update based on a match key?
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
You inspired me!
@@CurbalEN that is a first, from being normally the other way around 🤣
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
😂
@@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.
@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]?
Here is how you rename columns in Power Automate:
ua-cam.com/video/lWu4n-ODe4U/v-deo.html&ab_channel=Curbal
That's great, but what if I only want to add new items to the sharepoint list? How do I avoid duplication?
You append instead of create. Check the export playlist, it has a tutorial on append in excel, it might be similar.
The 2 dates with no sales in the Output look invalid?
I mention it in the video, there where no sales those dates.
how did you rename the columns
Here is how you rename columns in Power Automate:
ua-cam.com/video/lWu4n-ODe4U/v-deo.html&ab_channel=Curbal
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 ?🤔