Hello everyone, I’ve been trying to connect the Wix database (collections) to Power BI, but haven’t been able to do so.
I’ve also tried through Google Sheets or Excel online but still couldn’t do so.
Preferably, I’d like to connect without a third party (which only work free a few times).
Regards!
Create a page on Wix with everything in a standard HTML style table. Power BI can connect to a table of a website. That’s the fastest way.
I used Wix’s backend http-functions.js to expose my database collections via API, used Postman to call them to ensure it worked, then connected Power BI via API call (get data from Web data source in Power BI terminology). Attached are screen shots for
- Wix Backend https-function.js showing code for importing your database collections and exporting them (exposing them via web API url)
- Calling your newly exposed database collections via Postman to ensure they work
- Power BI Power Query Advanced Editor showing my full code
This worked like a charm, thank you so very much for the idea.
Worked perfectly, thanks! My dataset contains personal data. Is there a way to include some authentication to ensure data cannot be accessed by anyone who has access to the GET string?
@iaindowner I haven’t tried it, but this might work: https://support.wix.com/en/article/corvid-security-considerations
Any help appreciated here - when I create the http-function.js, with the example code (math example) all works well. I use Postman to test the calling of the function, and I get the expected outcome. When I change the example code for what I’ve shown below, I get a “500 Server Error” response in Postman.
This is an old thread and is being closed.
Further, this comment is off-topic to the thread. Please add your own issue into a new post instead of bumping up an old post. Explain what you are trying to do, what works, and what doesn’t.
Add any code in a code block (not a screenshot) as stated in the Forum Guidelines.