Forum Discussion
PowerBI not recognizing text data imported from PostgreSQL when creating visual graphs
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.
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?
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:
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:
Let´s see if i´ve done this right, these are the links for each file:
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.