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.

     

VBeaklini's avatar
VBeaklini
Helper I
3 years ago

I replied to my own post above instead of yours, posting this message here just in case you didn´t see it. Thanks in advanceif you can help.

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?