Forum Discussion
Custom Column Online Dataset
Hi All,
I'm a Power BI Newbie.
I would like to add some custom columns and using an online dataset. I cannot find this. I use Power BI desktop, and having a local dataset I can add columns but I cannot manage this having an online dataset.
3 Replies
Marten1984 , for direct query you can add custom column both in power query and DAX, but there are limitations
In Live connection you can not.
Usually simple calculation without row context is allowed
I explore few of them in my series here https://www.youtube.com/playlist?list=PLPaNVDMhUXGbKatyDdOhGbTL3xW2Xy6pA
Thanx for your answer.
I use a live connection. If I understand you correctly, I guess it is not possible?
I use a live connection because I want to refresh the date on a certain rate (to be defined, (1s - 60s) rate, main reason for choosing the live connection.
Hi Marten1984,
AFAIK, live connection mode has disabled most of the edit features so you can't add custom fields.
You can enable the 'direct query' mode for power bi service datasets to unlock calculate field but it also limited the Dax function usages in this mode.
Regards,
Xiaoxin Sheng
