Forum Discussion

VBeaklini's avatar
VBeaklini
Icon for Helper I rankHelper 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
Icon for Super User rankSuper User
3 years ago

Hi VBeaklini ,

 

Since you're just doing a free online course, the data must be sample data. Can you post the sample pbix? Maybe if I take a look I can likely see what is the cause of your issue.

 

Without seeing it, I'm guessing your Sales is not a numeric type, or perhaps you should create a measure to aggregate your sales amount.