Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have connected powerbi desktop to an e-commerce database using odbc connection. I created a table visual and use this to export some orders. Everything works fine except that it skips 3 rows in the table visual. These 3 rows are however visible in the query editor. I tried the options: Don't summarize and show items with no data. It still doesn't work. Does anyone have any idea why it may happen?
Solved! Go to Solution.
@Rosh89 , power bi always group the data, so if the two rows have the same values they will be shown as one even with do not summarize
@amitchandak Hi Amit, Thanks for the information. Is there any way to surpass this in powerbi itself? Does it also work the same way when creating other visuals? For ex. Card, bar graph etc.
@Rosh89 , power bi always group the data, so if the two rows have the same values they will be shown as one even with do not summarize
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
79 | |
74 | |
56 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |