cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Tamir Member
Member

Creating a table from a table visualization

Hello,

 

I have a table visualization that has a few columns based on DAX measures.

 

It has 500K records. 

 

I would like to export it to a CSV and would be happy to use the DAX stdio.

 

But...How do I "convert" the table visualization into a "regular" table to which I could query in the DAX studio?

 

Thanks,

Tamir

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: Creating a table from a table visualization

Sure, you would go into Modeling tab and then do a New Table. But, I would need to understand your source data and what you are doing in your table visualization. But, in theory it should just be something that uses the SUMMARIZE function.

 

https://msdn.microsoft.com/en-us/library/mt163696.aspx


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

View solution in original post

Tamir Member
Member

Re: Creating a table from a table visualization

Thank you!

 

That is precisely what I needed.

I did:

 

CostTable = SUMMARIZECOLUMNS(factsSalaries[Employee ID], factsSalaries[Employee Name],dimCalendar[MonthYear], "Cost USD", [TotTSAUSD])

 

and then with DAX Studio could extract the table into a CSV file.

(http://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-and-dax...)

 

Much appreciated,

Tamir

 

View solution in original post

15 REPLIES 15
Super User
Super User

Re: Creating a table from a table visualization

Why can't you just click on the ellipses (...) and select "Export data"?


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Tamir Member
Member

Re: Creating a table from a table visualization

Because of the 30K limitations. I have 500K records

Super User
Super User

Re: Creating a table from a table visualization

Oh yeah. Good point!


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Super User
Super User

Re: Creating a table from a table visualization

You might want to check out the Power BI REST API:

 

https://msdn.microsoft.com/en-us/library/mt147898.aspx

 


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Tamir Member
Member

Re: Creating a table from a table visualization

Due to Organisational restriction, I am afraid it is not an option...

 

Is there a way to do it with DAX? something like a virtual table?

 

Super User
Super User

Re: Creating a table from a table visualization

Sure, you would go into Modeling tab and then do a New Table. But, I would need to understand your source data and what you are doing in your table visualization. But, in theory it should just be something that uses the SUMMARIZE function.

 

https://msdn.microsoft.com/en-us/library/mt163696.aspx


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

View solution in original post

Tamir Member
Member

Re: Creating a table from a table visualization

Thank you!

 

That is precisely what I needed.

I did:

 

CostTable = SUMMARIZECOLUMNS(factsSalaries[Employee ID], factsSalaries[Employee Name],dimCalendar[MonthYear], "Cost USD", [TotTSAUSD])

 

and then with DAX Studio could extract the table into a CSV file.

(http://biinsight.com/exporting-data-from-power-bi-desktop-to-excel-and-csv-part-1-copy-paste-and-dax...)

 

Much appreciated,

Tamir

 

View solution in original post

mvalaboju Frequent Visitor
Frequent Visitor

Re: Creating a table from a table visualization

Can we create a virtual/dynamic table and use it in measures in excel using DAX? Appreciate your response.

Super User
Super User

Re: Creating a table from a table visualization

@mvalaboju - Yes, I do it all the time. You just specify a VAR and set that equal to your table equation/filter. Then you can use it within a measure.


I have book! Learn Power BI from Packt


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

Proud to be a Datanaut!

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 59 members 1,161 guests
Please welcome our newest community members: