Forum Discussion
Solved
PowerBI not recognizing text data imported from PostgreSQL when creating visual graphs
Hello i´m doing a free online course on Power BI, managing a very low amount of data in exercises to learn how to use the program and all, and the class just introduced PostgreSQL to us, teaching how...
Hi VBeaklini ,
In your file, there's an issue with the relationships. You're keys aren't lining up to give you the right results:
They're going to return blank because the keys don't match. Try adjusting it and see if that works.
Okay i know what is wrong, the data they sent us is all codified wrong. Observe that in TB_PRODUTO the Produto column are all written as SKU-XXXX, while in TB_VENDAS they are codified as SPXXXX. That is supposed to be the product id, they have to be the same in all tables. And in TB_VENDAS, the column TB_VENDEDOR (vendedor means salesman) has the same sku code that is used for the products... so it is all messed up. No wonder i can´t do anyting. Thanks for the help.