I’ve been working on connecting my Notion workspace to Power BI through the web data connector feature. When I try to establish the connection, I keep running into a 400 bad request error that’s blocking me from pulling any data.
I’ve double checked my API token and made sure it has the right permissions in Notion. The endpoint URL looks correct to me as well. I’m using the standard Notion API v1 endpoints for database queries.
Has anyone else faced this same issue when trying to connect these two platforms? I’m wondering if there’s something specific about the headers or authentication method that Power BI requires when making requests to Notion’s API. Any suggestions on what might be causing this 400 error would be really helpful.
Been through this exact headache myself. The issue’s probably how you’re building the database query parameters in Power BI. When I set mine up, I found that Power BI sometimes adds extra parameters or encodes characters differently than Notion expects. Test your API call in Postman or curl first - make sure it works outside Power BI. If it works there but fails in Power BI, you’ve got a formatting problem with how Power BI sends the request. Also check if you’re hitting rate limits - Notion throttles pretty hard and Power BI can fire requests too fast during connection setup.
definitely check the sharing settings on the notion database! i spent ages on errors too, thinking it was other stuff like the token. if the integration aint got access, it won’t work at all. gl!
The 400 error usually happens when Power BI’s web connector formats the request wrong. I ran into this exact problem - turns out Power BI was messing up the API request structure. Double-check your JSON payload in the advanced options. Notion’s really picky about how you format the request body. Also make sure your integration ID matches what you set up in your Notion workspace. One more thing - check if the Content-Type header is set to application/json. Power BI doesn’t always set this automatically with REST APIs, and that’ll trigger a 400 from Notion’s servers.