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 to import data from it and make some basic visual graphs.

 

However for some reason it is not working for me and i´m running into an error i do not understand, as i build a basic bars table of Sales x Product Category, the product category section on the x axis is blank, even though the data has been correctly imported from PostgreSQl (i can see the tables properly on the different tab). But if i try to do the same graph with Sales x Date, it works properly. I guess PowerBI is only reading correctly the data from the table when it comes to numbers, but not text?

 

Thanks for the help.

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.

     

11 Replies

  • hnguy71's avatar
    hnguy71
    Super 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.

  • VBeaklini's avatar
    VBeaklini
    Helper I
    3 years ago

    I don´t know how to attach a file to a post in this forums, and even though the data i´m working on is just a sample it´s still about 400+ rows to post it here, but i´m gonna try the first 10 lines so you can have an idea. Here is the Sales table:

     

    ID-ProdutoID-VendedorLojaData VendaValorVenda
    SKU-00000011009SP8821########679
    SKU-00000021006SP88211/1/2012832
    SKU-00000031006SP88212/2/2012790
    SKU-00000041003SP88213/3/2012765.32
    SKU-00000051004SP88214/4/2012459.89
    SKU-00000061005SP88214/5/2012590.98
    SKU-00000071006SP88214/6/20121000.91
    SKU-00000081007A99904/7/20121229
    SKU-00000091003SP88214/8/20121300

     

    The data is in brazillian portuguese. The first column is the id of the product, the second is the id of the salesman, the third is the store, the fourth is the date of the sale (day/month/year), and finally the last one, the one that matters for the exercise, is the monetary value of the sale. The next table is for the product:

     

    ID NOME CATEGORIA SEGMENTO MARCA
    SKU-0000002 Geladeira Duplex Eletrodomésticos Doméstico Brastemp
    SKU-0000007 Geladeira Duplex Eletrodomésticos Doméstico Brastemp
    SKU-0000009 Geladeira Duplex Eletrodomésticos Doméstico Brastemp
    SKU-0000011 Geladeira Duplex Eletrodomésticos Doméstico Brastemp
    SKU-0000012 Geladeira Duplex Eletrodomésticos Doméstico Brastemp
    SKU-0000013 Geladeira Duplex Eletrodomésticos Doméstico Brastemp
    SKU-0000014 Geladeira Duplex Eletrodomésticos Doméstico Brastemp
    SKU-0000015 Geladeira Duplex Eletrodomésticos Doméstico Brastemp
    SKU-0000028 Geladeira Duplex Eletrodomésticos Doméstico Brastemp

     

    From left to right we have id, name, category, segment and brand. In the category column, for the first 10 rows we have only one type, Eletrodoméstico (home appliance), but for the entire set of data we also have small appliances, cellphones and eletronics.

     

    Now here is where my problem lies: when i create a simple graph, a bar graph, placing ValorVenda (sales value) on the y axis and Categoria (category) on the x axis, i only get one bar for the categories when i should be getting 4. And the nameplate for the category is blank. I also get this error when i try to create the same graph with any other part of the data that isn´t a number (date or monetary). I never had this problem with Power BI, i´ve only run into it in this particular class i suspect because we are required to load the data first to PostgreSQL and then import it to Power BI to simulate we are managing a data base. So i think the issue might have something to do with PostgreSQL. Any thoughts?

  • 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?