Forum Discussion
Convert query to static table
- 7 years ago
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
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?
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