cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper V
Helper V

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
Highlighted
Super User IV
Super User IV

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


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

Highlighted
Helper V
Helper V

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 IV
Super User IV

Re: Creating a table from a table visualization

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


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Highlighted
Helper V
Helper V

Re: Creating a table from a table visualization

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

Highlighted
Super User IV
Super User IV

Re: Creating a table from a table visualization

Oh yeah. Good point!


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Highlighted
Super User IV
Super User IV

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

 


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Highlighted
Helper V
Helper V

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?

 

Highlighted
Super User IV
Super User IV

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


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




View solution in original post

Highlighted
Helper V
Helper V

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

Highlighted
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.

Highlighted
Super User IV
Super User IV

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.


---------------------------------------

Putting square pegs in round holes since 1972.

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors