Fixed by giving azure sql storage permission On Azure and app id read permission to the workspace of Fabric