Forum Discussion
PowerBI not recognizing text data imported from PostgreSQL when creating visual graphs
Let´s see if i´ve done this right, these are the links for each file:
Hi VBeaklini ,
The link works. Fantastic work.
I think your issue is that your data needs to be transformed to be usable and is possible why you're only getting one column. I've attached the model for you to view based on the information provided. Let me know if this is what you're looking for.
Okay, when you do it it works, but let me remind you that for this exercise we are supposed to upload those csv files to a data base in PostgreSQL, and then import it to PowerBI to play with it by making some graphs.
My mistake i should´ve sent the PowerBi file with the error in it in the first place, yeah i guess i have to transform the data somewhat but the class i´m on is automated and they´re not instructing us to fix anything, the data should´ve worked with no tempering required. And i don´t know what to transform in the data to make it work. Here´s the pbx file see if you can find what is wrong with it:
https://1drv.ms/u/s!AkA0_hLZOtc1gSJ6Yb6OOWn4QfvA?e=VJw5TZ
Thanks for the help.
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.