The invention discloses a preparation method and application of a hierarchical pore metal-organic framework loaded heteropolyacid catalyst. The catalyst adopts hydrothermal-extraction method for preparation. The method includes: dissolving an organic ligand, a template agent, a metal salt and Keggin type heteropolyacid in a solvent, conducting hydrothermal synthesis of a crystal product, and thenperforming Soxhlet extraction to obtain a catalyst. The obtained catalyst has a meso-micro hierarchical porous structure, realizes high dispersion of the active component heteropolyacid and ultra-highloading capacity, and at the same time solves the problems of large mass transfer resistance, long diffusion path and small reaction place in microporous materials. The catalyst provided by the invention shows excellent catalytic performance in both photocatalytic degradation of dye wastewater and catalysis of oxidation-extraction desulfurization reaction, the catalysis reaction uses visible light and hydrogen peroxide respectively, the process is clean, environment-friendly and green, and after repeated use, the catalyst still maintains high activity, and has high industrial application value.