Forum Discussion

Luklaman's avatar
Luklaman
Regular Visitor
5 years ago

Bugs

Hi, I think I have found two bugs in PBI and am interested to know if people think they are bugs, or have experienced these issues. I have a PBI report combining 20+ Excel files from multiple differe...
Need Help
Luklaman's avatar
Luklaman
Regular Visitor
5 years ago

Thanks Matt.

 

That has resolved one of the vendors, however I still have two vendors that have not been removed.  I have a vendor called "AMERICAN" and it appears as such in the raw data and the query used to flag Internal vendors.  American is in upper case in both tables and is 8 characters long, but despite this "AMERICAN" remains flagged as an internal vendor.

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
5 years ago

These things can be challenging because you can't "see" what is happening. Try adding a step in each table query that filters just for the problem item before they are joined. This may help you see what is happening.