Unleash the Power: Connect Notion to PowerBI or Excel
HTML-код
- Опубликовано: 18 сен 2024
- Here's how to connect Notion with PowerQuery.
There are quite a lot of steps you need to perform before you get there, but I've explained everything in the video:
- Choose a Notion Database to get the data from
- Create a Notion Integration
- Connect the Notion Integration to the database
- Get the integration API key and store it in Excel
- Get the Notion database ID
- Perform the requests
- Unwrap the data in PowerQuery
I'll be really happy to answer any of your questions. If you'd like to see me connecting to more Web services, just write a comment and I'll make a video on that as well.
Also - Merry Christmas to all of you!
We need to watch the video to learn how to extract more records with PowerBI from Notion, beyond the first 100. This video is exactly what I have been looking for a long time, it's awesome!
Agreed :D That one's here: ruclips.net/video/W8HLP4MrqGU/видео.html
Hi Lovro, thanks to you I was able to put my Notion data into Excel. Now I wonder where to go next and start crunching my data to get some cool sales graphs. Again, thanks!
Excellent demonstration good job 🔥🔥🔥 it's seems more complete than a lot of python tutorials that I watched. Big thank you
Thank you! Means a lot!
Hello,
I was trying to connect notion to power bi form many month. I know that in some pages you can find discussions about it, but since I don'y have a deep knowladge about coding, I never managed to accomplish it.
Thanks to ou I finally manage to do it! So thank you so much =D !!
In your video you mentioned 2 situations that you could make a separate video about.
1) about the limit of 100 lines that we are getting of notion
2) a more optimal way to get to the end result, that in this current video we were using power query interface to get it
I think it would be a great aid, especially for people like me that don't have a deep understanding of code
Right now the think that I would like to solve is the 100 line limit, since I'm planning a complex project in notion, and for sure I will surpass the limit soon.
Either way, thank you so much for the great content, and hope to see more videos about it. You got yourself a new subscriber =D
Cheers from Brazil!
Thank you so much for such a kind review! Now that you've asked for it, I'll make the second video a priority :)
@@lovrosbizappsThank you so much!! Excited to watch your future content!!
Thank u very much man, very usefull
Thank you! Glad it helped!
The video is excellent. However, to be really useful, it would have to read other database identifiers. This would allow access to related properties, for example projects & tasks, in the same database, providing graphs such as the number of tasks per project
Great idea for another video :) Do you maybe have a template for the setup you're explaining? That would be awesome!
so good
Your videos are great! I like the pace and details of them. Is it possible to have it 2 way? Where I could make new rows in excel and they would show up in Notion and Vice Versa?
Yes! It's possible, there are many ways to go about it. Stay tuned ;)
16:22
it gives me problem
we couldn't authenticate with the credentials provided. please try again ..
and I already cleared data source as you did but it doesn't work .. do you have idea about how I can solve this ?
thanks ❤
Got same problem. Were you able to fix it?
@@joaquinnavarretechavez9605
Unfortunately no , Um used grid.is instead excel
Did you manage to resolve the credentials issue? Mine won't go at all
Hey, sorry for late response - could you record a Loom and demonstrate the issue there? I'm not sure I fully understand what's causing the issue :/
I would like to see how to do it the other way around. I want my notion to update based on changes made in excel
Real time?
@@lovrosbizapps Yes, is this possible to have it work both ways? As rows are added in excel, Notion is updated and if status' are updated in Notion it updates back to Excel. Or if a Notion page is added, it will add to excel etc.
This seems to be a popular request, stay tuned ;)
Hi Lovro, Good Information, I'll try to do.
🥰 tks
Thank you!
It is so helpful. I got a problem with the query, when I want to manipulate it, it only allows me 100 rows and my data has 220 rows. What can I do
Hi, were you able to resolve the issue with the credentials?
Have you figured out the problem? I´m struggling with the same thing
Hey everyone, so sorry for the late response - here's the other video which shows how to get all the records: ruclips.net/video/W8HLP4MrqGU/видео.html
Is need to pay for to do the integration?
Hey, happy friday! No, its free :)
ı am getting the errror "we couldn't authenticate with the credentials provided. please try again"
and I already cleared data source as you did but it doesn't work
Sorry to hear that :/ Did you manage to fix the issue?
Hi Lovro, Im having this Error:
Expression.Error: 'headers' isn't a valid Web.Contents option. Valid options are:
ApiKeyName, Content, ExcludedFromCacheKey, Headers, IsRetry, ManualStatusHandling, Query, RelativePath, Timeout
Hi Jorge, can you double check if your Headers is spelled with uppercase H, like "Headers"? PowerQuery is case sensitive. If that doesn't help, just send your code through PasteBin and I'll have a look :)
@@lovrosbizapps Same problem