Forum Discussion
Power query mismatch
I am having an issue with my data which is imported from a CDS using Msft Dynamics
When I load the data I can see all the columns and their rows,But when I close and apply and then go to Data view in the power BI desktop I have one of my column that has all its field missing (Blank)
I have check the data type was correct(Text)
so in other words:
ie I can see Column B showing all information in Power query and When looking in data view the rows are blank
Can you please help?#
Many thanks
Hi, Anonymous
You may click 'Refresh' button to check if there is still no data loaded. Then you may go to 'Query Editor' to see if the last step of the query return all data you want. You may also check if the data in the data source is updated.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
Anonymous Please check if after importing data in powerbi desktop, do you see any error appearing. Also check if null values or #NA values in your dataset. if your data does not have these null values and still your powerbi is not showing the coplete data then you may try exporting or copying the data from powerbi dataset to an excel file or text file to check if all rows/columns are present in the data. You can also use the measure countrow to check numbers of rows in your data.
Let me know if above suggestions work for you or not
Hi, Anonymous
You may click 'Refresh' button to check if there is still no data loaded. Then you may go to 'Query Editor' to see if the last step of the query return all data you want. You may also check if the data in the data source is updated.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
