Which Power BI license do I need?

You need at least a Power BI Pro license to connect datasets in a shared workspace.