Although LP means you are loss limited to the amount you have invested, you may not apply the tax write-offs toward ordinary income—only passive income. However, you still have the same liability as the General Partner.
You may want to check out JVs where you are an actual owner of a business enterprise and enjoy all the risks, but also the rewards such as tax advantages on all income, not just passive.