Convert query to static table

[accortdr]

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 need to put the current data into static tables that will not be updated and will add a new date field that will contain forward looking dates (~5 years ahead) so that certain metrics will continue to be valid (MTD, YTD, QTD, etc). I no longer have access to the server credentials, so am limited in what I can do in the query editor. Additionally, the data is so massive that copy/paste into a new table is not an option without breaking it up and appending later which will be extremely time consuming. Is there another alternative?

Summary: I need to take exisiting data and break the connection to SQL server and put it into a static table for further manipulation.

Thank you

[Greg_Deckler]

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

[accortdr]

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?

[v-yulgu-msft · Accepted solution]

Hi @accortdr ,

You can export data model that imported into Power BI desktop via DAX studio or SQL Server Analysis Service. Please take a look at below links for detailed steps.

Exporting Data from Power BI Desktop to Excel and CSV – Part 1: Copy & Paste and DAX Studio Methods

Connect to Power BI Desktop Model from Excel and SSMS

Best regards,

Yuliana Gu