Connecting from Power BI to appwrite

Is it possible to connect as power bi data source.

I would recommend connecting directly to the REST APIs: https://appwrite.io/docs/rest

Technically, if you're self hosting, you can connect to the mariadb database directly, but i don't recommend it because we use internal ids for things so you might have a hard time finding the right collection

how data are shown by connecting with rest ?

same as using the SDKs

any use case of connecting to power bi

sample .

all of our docs have REST example requests if select REST in the Client Integration drop down: https://appwrite.io/docs/client/databases?sdk=rest-default#databasesListDocuments

We also document the response payload

it would be hard to use for visualization by power bi.

what do you mean?

can it response as whole database

what? no, you can't fetch the entire database in one request. you must paginate

thinking how it will be working with power bi.

lets say querying data for showing some calucations , statical report