Forum Discussion
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.
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.
Much appreciated,
Tamir
Community ChampionWhy can't you just click on the ellipses (...) and select "Export data"?
Because of the 30K limitations. I have 500K records
- Greg_Deckler
Oh yeah. Good point!
- Greg_Deckler
You might want to check out the Power BI REST API:
https://msdn.microsoft.com/en-us/library/mt147898.aspx
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?
- Greg_Deckler
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.