cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Export issue

Two questions

 

Is there a way to see how many rows a power bi report has in atable or matrix?

 

I built amatrix and tried to export it but the sales total of the excel export wont tie to whats in PBI and I have no idea why. to give an idea of scale what does export is about 120k excel rows. Any idea what the issue could be?

7 REPLIES 7
Super User
Super User

Re: Export issue

If all you have access to is the Service then I can't think of a way off the top of my head. Other than if you click on the Dataset and create a new report, pick a particular column out that you want and do a Count aggregation. Do you have access to the Desktop file (PBIX)?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Anonymous
Not applicable

Re: Export issue

I have access to desktop and I made this report myself. Can't export out of desktop due to file size

Super User
Super User

Re: Export issue

If you click on the Data tab over on the left and then on a table, at the bottom will be the row count. Is that what you are looking for?


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Anonymous
Not applicable

Re: Export issue

I do not see that

Super User
Super User

Re: Export issue

Weird, you don't see this:

 

image.png

 

It should also be in Query Editor:

 

image.png


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Anonymous
Not applicable

Re: Export issue

I definitely do not. It is a live connection to a cube though

Community Support Team
Community Support Team

Re: Export issue

Hi @Anonymous,

 

You can try to write a measure to with count row function to get count of current row contents, drag it to matrix visual value field and it will show total row count on total level.

Measure =
COUNTROWS ( Table )

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |