Forum Discussion

accortdr's avatar
accortdr
Helper I
7 years ago
Solved

Convert query to static table

I am attempting to convert a dashboard that is fed from SQL server into an example piece to be shown to an audience outside of our organizaiton. Because this will no longer be a "live" dashboard, I n...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
7 years ago

Perhaps try putting all of your columns into a Table visualization. Then, click the ellipses (...) and choose "Export data"?

accortdr's avatar
accortdr
Helper I
7 years ago

Greg,

 

Appreciate the thought! I had considered that as an option, but there is too much data for the visual to process which makes me hessitant to try and pull it through excel and back into PBI. Is it possible for me to take a portion of the data from Data View and put it into its own data table?