Forum Discussion
Helper IIIPower Query has fewer rows than power bi datamodel? #postgreSQL
Hello again,
I stripped my problem down to the (I think) smallest piece of data an M-code. I attach all necessary files in a ZIP-file. It woulld be so nice if someone with a running postgreSQL instance can reproduce my problem - and if you can: someone can tell me where to send a bug report to microsoft?
The file contains the following files:
1) createDatatype: This creates an enumeration datatype. I need to select this column to reporoduce the error.
2) the ddl of the table with the data
3) the insert statements (about 23.000 rows with just 3 Columns)
and for sure: the power bi file. You just have to change the database server and the database.
I found these obervations:
- If there is no index on the "id" column, the duplication does not happen
- The transformation "select columns" is necessary. Otherwise no duplication happens
- you need to select the enumeration column. Otherwise no duplication shappens.
- the sort is necessary. Otherwise no dulication happens
I think the reason is hidden behind
- query folding
- paging with using the index
- the enumeration
Thanks everybody for your support!
Holger
PS: I was not able to insert attachments to this post - I always get exceptions like "txt is not supported, pbix is not supported,...". So here is a dropbox link:
Hi All
Firstly amitchandak thank you for your solution!
And ppvinsights ,Based on your description, I just tested it in my environment. The data is also realisable in Power Query and BI, I think your problem may be that after loading into Power BI, there is an issue with the model relationships causing the data to reoccur.
Can you post a table structure with some sample data that reproduces the problem? It would be better to share the example pbix file. This will be more helpful for us to help you to solve the problem, I hope my answer can help you, here are the cases I found for you which are related to you, I hope it will be helpful for you.
Solved: Re: Expanding columns after a Query Merge increase... - Microsoft Fabric Community
Best regards,
Community Support Team_ Tom Shen
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
- ppvinsights
Hi,
Anonymous
I am not sure if you got notified by my answers. I tried to strip my problem down to the smallest set of data and M-code. You find it in my posts in this thread. Are you able to reproduce my problem?
Thanks
Holger