Empty Table / Bad Request / Invalid Expression

Anonymous · ‎10-26-2021

Hi everyone,

So i have finally figured out how to pull data from Project Sites in Project Online (following this link -Want to query cross #project site #SharePoint lists in #ProjectOnline / #ProjectServer ? #PowerBI #P...)

However, it now either says my table is empty, or if i try to pull columns through it says i have a 'Bad Expression' and the data is invalid. Below is the code i am using. It doesn't seem to like the bit after 'Select'. If i don't include anything in that bit, it pulls through the table but it then says This Table Is Empty and doesn't allow me to select any columns. Anybody know how to fix this?

let ActionLog = (site as text) =>
let
Source = OData.Feed(site&"/_api/web/lists/GetByTitle('Action%20Log')/Items()"$?Select=Action%20Description,Action%20Owner, null, [Implementation="2.0"])
in
Source
in ActionLog

Anonymous · ‎10-29-2021

Hello,

Yes, I am definitely connected through OData feed. The problem I have is, when i expand the columns, it says 'no columns were found', even though i've asked it to find Action Descriptionn and Action Owner.

Thanks