How to create a table rom a visualization

[sbolton1855]

I have created some DAX and used for visuals with calculations and the table is EXACTLY the data I need.  Is there a way without exporting and reimporting that I would be able to create a data table from the table visual to use in other visuals? I am trying to avoid this bc of the export row limit 

[Mikelytics]

Hi @sbolton1855 ,

I think what you want to do is not possible like you expect. BUT what you can do is the following. Open Excel and connect to the dataset of the report. Then you can create a pivot table based on all the fields and measures which are in the dataset. The only thing you need to do is to change the pivot layout to table as well as to repeat the element names and then you can do stuff like in the picture below:

As you can see in the picture based on the daaset in power bi service I used the fields and measures to create a table which you can refresh at any time.

I hope this helps.

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.