I am currently using airtable and a DAX expression with an API call to bring data into powerBi. The process take a long time, and I'm working on integrating the powerBi dashboard in our website so I would like it to be near real time. What is the best way to view data from xano using powerBi? Is there a way to connect Xano directly via the postgreSQL Connector?
https://learn.microsoft.com/en-us/power-query/connectors/postgresql
Alternatively I could make an API call similar to what I am doing for Airtable and would have to find someone to write some custom DAX code. (which I know nothing about)
We have some powerBi specific features that would make it difficult to use an alternative tool like Retool.
I found this on the internet https://precog.com/integrations/xano-to-power-bi/ but not sure we need a thrid party solution.