Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

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. 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    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?