Loading of Data

[maynkk]

After merging two tables, in power query when i try to load that data into powerBI, it keeps on loading and get stuck at this particular point, after which neither it get's completed nor it shows any error.
Please help.
Attaching ss for reference

[Anonymous]

I would add a Table.Distinct/Remove Duplicates step to that Excel file's merge column, so that Power Query knows that it's a distinct column. It may already be distinct, but if you specifically enumerate that fact to PQ, it'll probably be much, much faster.

--Nate

[MAwwad]

There could be several reasons why your data is not loading into PowerBI after merging two tables in Power Query:

1. Large data size: If the merged data set is large, it may take some time to load. In such cases, consider reducing the data size by filtering or aggregating the data before loading it into PowerBI.

2. Incorrect data types: Incorrect data types can cause issues while loading the data. To resolve this, you can go to the Power Query Editor and check the data types of the columns. If necessary, you can change the data types to match the expected data types.

3. Data corruption: If the data is corrupted, it may cause issues while loading it into PowerBI. In such cases, you can try creating a new copy of the data and then loading it into PowerBI.

4. Network issues: If you're facing network issues while loading the data, it may cause the loading to get stuck. In such cases, you can try reloading the data after a few minutes, or when you have a better network connection.

If these steps don't resolve the issue, it would be best to reach out to the Microsoft PowerBI support team for further assistance. They may be able to provide you with more information on why the data is not loading.