Hi,
Problem scenerio: a pbix was using mongodb as the data source with 10 columns, now that table has been migrated to hive and all the column names have been renamed, however the values are same in addition 4 new columns have been added to the table.
Is there any way to keep using the existing pbix by making the changes in power query editor?
kindly help!
Yes, it is possible to keep using the existing pbix file by making the necessary changes in Power Query Editor. Here are the steps that you can follow:
Note: It is recommended to take a backup of the original pbix file before making any changes to it.