Forum Discussion
Merged queries suddenly stopped working in data model
Help, I have many merged queries in Query Editor and the data is fine there. However, the data in the merged columns are not being displayed in the data model. It has been working fine up until today and I have no idea why it stopped. Please see the screenshots below.
Has anyone got any ideas on how to fix this?
3 Replies
- amitchandak
Super User
DanielHart , query editor shows only a few rows. Just sort and check if there is something missing or having the error
Filter on the same siteguid and check. Also, see if there is some error. Highlighted in yellow color
refer how to handle error in power query
https://www.youtube.com/watch?v=OE6DPmKqN7s
https://www.youtube.com/watch?v=9-Lag0VOiTs - Fowmy
DanielHart
Try to reimport the data
or
copy and paste your queries to a blank PBIX file, delete the queries then paste those original queries back.________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
HI DanielHart,
Query table existed the row index and it will try to keep the raw data source structure and sorting order when loading records.
When they convert to data model tables which not include column/row index and the records may not display the same sorting as your data source/query table displayed. (blank records may display to the front of others)
I'd like to suggest you filter records with blank value to confirm if other value loading correctly.
Regards,Xiaoxin Sheng
