Forum Discussion
More rows in Power Query than Data view
Hi Anonymous ,
First, in Power Query, go to the Home tab and hit Refresh Preview. Check your row counts.
If you don't have a match now then, in Desktop, go to the Home tab and hit refresh. Check your row counts.
Let me know if you still have an issue after this and we can dig a bit deeper.
Pete
Hi, I´m facing the same situation, and just refreshing is not helping me out.
The data are from a software and stored in ADLG2. I have this particular column define as a text by the developers, but it is heterogene, since i have digit, non-digit, text, as well as numbers with + or - in front (i.e. +3days). there is an unique code for the different parameters.
I did in a previous steps a copy of the values column and transformed it numeric. then i got "error" in the rows, where i had something else than numbers (digit and non-digit) and replaced the "error" by "null". even though... all parameters are still not visibles in the report view.
Can you please help me out? i´m copletly lost
Hi beginner_bi ,
Please raise this as a new forum topic.
If your issues are with Power Query, then raise to the Power Query forum. If they're with DAX/Data Model then raise to the Desktop forum.
Make sure to include detailed information about your problem to help others help you. Great info on getting your questions answered quickly here:
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/2973705
Pete