Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
When i am extracting the data form the table it is giving only few data not complete. However count is mataching as per card and also the raw data.
Kindly help in fixing this issue
Solved! Go to Solution.
Hi,
I am follwing the first option of exporting summarized data, however i found the issue. It was with one of the mesaure which calucaltes Avg value hence it is not extracting all details due to this.
Thank you so much for your help and now issue is fixed.
Hi, how are you exporting? how many rows are you expecting?
There are two ways of exporting.
Remember you have limitations like:
The maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a .csv file is 30,000.
The maximum number of rows that the applications can export from an import mode report to an .xlsx file is 150,000.
I hope that helps,
Happy to help!
Hi,
I am follwing the first option of exporting summarized data, however i found the issue. It was with one of the mesaure which calucaltes Avg value hence it is not extracting all details due to this.
Thank you so much for your help and now issue is fixed.
I'm glad you fix it. If my last answer has helped, then please consider Accept it as the solution to help the other members find it more quickly.
Regards,
Happy to help!