cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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


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

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

 

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"?


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!


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

 


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

Proud to be a Datanaut!


Highlighted
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


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

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

 

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.


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

Proud to be a Datanaut!