Can I use Power Query\BI with the clould version?

You can check this post:

API using excel