Empty Table / Bad Request / Invalid Expression

[Anonymous]

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]

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

[v-eqin-msft]

Hi @Anonymous ,

Refer to this official document  to check your data source firstly:

Project Online: connect to data through Power BI Desktop - Power BI | Microsoft Docs

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.