General Question

[gusdahu]

Hello,

Currently I have data feeding into Power BI directly from PeopleSoft. However, I am unable to utulize certain functions such as relationships, edit query, get data, among others. Is there any way I could utilize these functions while still maintaining a direct feed from PeopleSoft?

More importantly, I need to split cells, and concatinate other cells to perform the analysis I want. Any help will be appreciated.

Regards,

Gus

[BKirsch12 · Accepted solution]

DirectQuery mode does not allow for this. You'll need to use import mode to have the full functionality of PowerBI Desktop.

https://docs.microsoft.com/en-us/power-bi/desktop-use-directquery