Fix the “Enter data“ limitation in Power Query

If you are trying to import data in Power BI using Power Query “Enter Data“, you might see this message: “The clipboard contents are too large to be pasted into the table. Please split your data into multiple tables with less than 3,000 cells“. In this video I will show you one way to get around it. Here you can download all the pbix files: SUBSCRIBE to learn more about Power and Excel BI!