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

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?

hnguy71's avatar
hnguy71
Super User
3 years ago

Hi VBeaklini you can send me a personal message via the forums and I can supply you my email address. Alternatively, you can create a free onedrive account located here:

 

 https://onedrive.live.com/

 

Once you create the account, you can drag-drop your sample csvs or pbix and click the share button:

 

 

Then click copy link button to share the link with the community:

 

 

 

    • hnguy71's avatar
      hnguy71
      Super User
      3 years ago

      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.

      VBeaklini-ETL-Sample.pbix46 KB
      • VBeaklini's avatar
        VBeaklini
        Helper I
        3 years ago

        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.