Power BI shared dataset limitation?

[alexlibby]

Hi there,

I would like to build a report in Power BI Desktop using a shared dataset and am running into an issue. I am unable to connect to a shared dataset and then add a calculated column OR add data from another source. If you use a shared dataset are you limited to the transformations you can then make?

[alexlibby]

Thank you very much! This worked!

[amitchandak · Accepted solution]

@alexlibby , In the case of a Live connection, You can not add another source or new column. You can convert it to a direct query model and do that

Direct Query https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...