Power query mismatch

[Anonymous]

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 

[v-alq-msft · Accepted solution]

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.

[Anonymous]

thanks so much

[negi007]

@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