We want to create reports in Power BI and we need to expose BC data that's currently not available in the standard APIs, so we thought on creating API Queries but I've read some posts were people ask about custom APIs and the responses suggest using Pages, so not sure why would that be? we just need readonly APIs, is there any reason to use Pages instead of Queries?
Also, we don't have a datawarehouse/datalake, I hope at some point we can get there, so I'm not sure where to build the facts/dimensions for the modeling in Power BI, should I do it when building the query API? or should I create a query per table and then use power query to create the facts/dimensions?
