I'd like to suggest you use dataflow. Power BI introduces dataflows to help organizations unify data from disparate sources and prepare it for modeling. Analysts can easily create dataflows, using familiar, self-service tools. Dataflows are used to ingest, transform, integrate, and enrich big data by defining data source connections.
For further information, you may refer the official document .
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.