Mergerd table is not working properly with documentdb-odbc-connector

[Anonymous]

Hi all,

We are using Amazon Documentdb for backend and powerbi for reporting. I have integrated powerbi with aws document db using document-odbc-connector and configured it in odbc administrator (64bit). Added both user DSN and system DSN using TLS and SSH tunnel (without known-hosts). Data connections are made in powwerbi also. 

I needed a table which merges 4 to 5 other tables and i did it in power query editor. When I try to apply the changes, its throwing me this error. 

All the access permission are given in database but then i couldn't make the modifications i need from power query editor.

Other than this, creating measures/ calc columns are working in power query editor. Creating a new table alone is not working

Is this a problem with the odbc connector or Is there any changes i need to make in powerbi ? 

The modifications in power query editor could be needed in future aswell. 

[lbendlin]

I needed a table which merges 4 to 5 other tables and i did it in power query editor

If possible, avoid merging in Power Query. Let the data model do the work for you.

 creating measures/ calc columns are working in power query editor

That's not something you do in Power Query editor - you do that in DAX.

Can you load all your data sources independently?