Forum Discussion

seankoh's avatar
seankoh
Frequent Visitor
8 years ago
Solved

Column cannot be found or may not be used in this expression

Hi all, 

 

I previously have a set of perfectly working Power BI reports which obtains data from my MongoDB using R script. Recently my IT administrator changed the IP address of the database so all I did was edited the IP address in my R script and now I am getting this error. All my visuals are not working anymore.

Can anyone please help?

 

Thanks.

Need Help
  • seankoh's avatar
    seankoh
    8 years ago

    I found the solution. Instead for editing the query for all the tables you have and applying it all at once, do it table by table.

     

    For example, edit your query for the first table, then click apply. Repeat the same process for all other tables.

1 Reply

  • seankoh's avatar
    seankoh
    Frequent Visitor
    8 years ago

    I found the solution. Instead for editing the query for all the tables you have and applying it all at once, do it table by table.

     

    For example, edit your query for the first table, then click apply. Repeat the same process for all other tables.