cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
seankoh Frequent Visitor
Frequent Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
seankoh Frequent Visitor
Frequent Visitor

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

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 1
seankoh Frequent Visitor
Frequent Visitor

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

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.