Create a data connector to ArcGIS Online feature services from Power BI. This would allow the reading of tabular data from hosted feature services either in public or preferably in organization layers.
Thanks for reaching out - apologies for the huge amount of time between you posting this and my response.
Unfortunately this is not on the road map for this product for 2019. We will however keep it in mind for the future.
This would be a fantastic functionality that our organization needs
The query function returns JSON, so you can do this already. Create a blank query and use:
let Source = Json.Document((Web.Contents("http://YOURFEATURESERVICE/x/query?where=1%3D1&t...&f=pjson&token=xxx")))in Source
Then convert to table and expand list fields.
Retrieving data ...