Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Power BI & MongoDB

  Hi Everyone!   I´m working with MongoDB as data source of my Power BI. I created a ODBC conector with this driver: https://www.progress.com/odbc/mongodb?sfdcid=701a0000002MkKS&cmpid=ddblog   ...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi Greg_Deckler!

    Can you explain me more about this way you told me?

    I don't see exactly what steps I have to do and the interaction between R and Power BI.

    Thanks!

    • Greg_Deckler's avatar
      Greg_Deckler
      Community Champion
      9 years ago

      In the Desktop, you can create entire queries based on R or individual steps within a query based upon R. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi Greg_Deckler!

        I have created a Query based on R script to connect with Mongo DB but the table show me an ERROR colummn.


        My R-Script is like this:
        library(mongolite)
        m<-mongo(collection="AVE",db = "MIURA",url = "url", verbose = F)
        Query<-m$find(query = "{}", fields = "{\"_id\":0}", sort = "{}", skip = 0, limit = 0, handler = NULL, pagesize = 1000)

         

        And the resulting table is this:

         

         

        I can't show the arrays inside of the clients column.
        Someone can help me???