Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Empty Table / Bad Request / Invalid Expression

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 #PowerQuery #BI #Office365 #Excel #PPM – Modern Work Management – Project and the Power Platform blog (wordpress.com)

 

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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