Forum Discussion

VBeaklini's avatar
VBeaklini
Helper I
3 years ago
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...
Need Help
  • hnguy71's avatar
    hnguy71
    3 years ago

    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.

     

hnguy71's avatar
hnguy71
Super User
3 years ago

Hi VBeaklini ,

 

With your sample data there's only 1 category. The rest of the product IDs are missing categories. How are you expecting 4? Can you copy and paste a larger sample data? If you can share the pbix via OneDrive public link that would be nice to see your actual model.

 

 

VBeaklini's avatar
VBeaklini
Helper I
3 years ago

There are four categories (Eletrodomésticos, Eletroportáteis, Eletrônicos and Celulares), they are just not in the first 10 rows. I don´t know if it´s the language barrier or the fact that the copy and paste truncated the title of the columns and it made it a bit confusing, but it should be something more like this

 

ID :  SKU-XXXXXXXX

Nome : Geladeira Duplex

Categoria : Eletrodoméstico

Segmento : Doméstico

Marca: Brastemp

 

I dunno how to set a one-drive thing, public or not. Maybe i can send you an email with the csv files?