Hey This helps... I have an issue from csv file .. I have connected csv from sharepoint folder to power bi and it does loaded , I could get the same no of rows in csv as well as in power bi but the rows were missing..not sure what's the problem is... no filter applied... just wondering how come the count from both the source and power bi are same but whyI was not able to see some of the rows in data table. Plz help
@@BILingualAnalytics Thanks for the response 👍, it's in power query editor and I have selected load more option where I could see all the data. Actually the number of rows are accurate and I can see the data after I have cross verified today but the problem is i was not able to get the correct data due to date field . In power query editor the dates are by default taking mm dd yyy and I tried changing it based on csv date field format but still it's just taking the date field as it's own. Example in csv file if date is 12( dec) / 08(dd)/2024 but in power query it's taking 08( Aug)/12(dd)/2024. FYI- csv file has a dynamic content and it has 100 k + data, and even in csv I was not able to change the date , it's just don't change... Nit sure if I ve explained my prob here correctly, plz assit if you could.
@@pragas4288 oh okay, so it's a data type/conversion issue. instead of just using 'Date' as a type try to use 'Locale' and specify the date format (ie US/AU/GB/etc). This way you can ensure the right format will be used and your figures will align :)
Were you aware of these solutions? Do you have an alternative solution to the same problem? Let us know here 👇
Thanks from South Africa.
Happy to help! :)
Hey This helps... I have an issue from csv file .. I have connected csv from sharepoint folder to power bi and it does loaded , I could get the same no of rows in csv as well as in power bi but the rows were missing..not sure what's the problem is... no filter applied... just wondering how come the count from both the source and power bi are same but whyI was not able to see some of the rows in data table. Plz help
Do you mean in Power Query or in Power BI Desktop? If it's PQ my guess would be that you have more than 999 records and only a preview is showing.
@@BILingualAnalytics Thanks for the response 👍, it's in power query editor and I have selected load more option where I could see all the data.
Actually the number of rows are accurate and I can see the data after I have cross verified today but the problem is i was not able to get the correct data due to date field . In power query editor the dates are by default taking mm dd yyy and I tried changing it based on csv date field format but still it's just taking the date field as it's own. Example in csv file if date is 12( dec) / 08(dd)/2024 but in power query it's taking 08( Aug)/12(dd)/2024.
FYI- csv file has a dynamic content and it has 100 k + data, and even in csv I was not able to change the date , it's just don't change...
Nit sure if I ve explained my prob here correctly, plz assit if you could.
@@pragas4288 oh okay, so it's a data type/conversion issue. instead of just using 'Date' as a type try to use 'Locale' and specify the date format (ie US/AU/GB/etc). This way you can ensure the right format will be used and your figures will align :)