How to store the filtered data in a permanent table

[wokka]

When you create a graph in powerbi you have the option to display as a table.

I have a SQL DBA background, so I'm familiar with temporary tables.

I was wondering how do you directly access this table of data that exists after all the filters have been applied , the same table that the graph is created from please? 

I'm sure it has to exist somewhere in order to display it and if so , how do we save it as a permanent table please?

Thank you in advance.

[v-xianjtan-msft]

Hi @wokka 

Here is a possible solution:

1. In the Power BI report, select the table view you want to export. Use the Export Data feature to export the data to a CSV or Excel file.
2. Import the exported CSV or Excel file to a server that stores other data (e.g. SQL Server) to create a permanent table.

A similar solved case for your reference:

Solved: How to store a permanent table in PowerBI - Microsoft Fabric Community

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[wokka]

Hi Jarvis,

Thank you for your reply.

You can see this data shown as a table behind a graph when you go "Show as a table " -  so that table has to exist in memory or on disk somewhere.  I am trying to find how to access that memory / disk location of that table so I can run calculations against it and/or save it to use after I shut down powerbi. 

[v-xianjtan-msft]

Hi @wokka 

In Power BI, "show as a table" is generally a dynamic result generated by the data model and not stored separately in some cache. If you want to reuse this table later, "Export data" is the easiest and most efficient way.

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[OktayPamuk80]

Hi Wokka,

DAX Studio is a tool that helps you understand e.g. measure execution. If you open a Power BI report, you may see in the task manager that in the Power BI desktop application, there is also an analysis services running. So, in the background it creates multiple temporary queries (resulting in temporary tables) for the time of calculation period. There is also caching happening, that leaves always some memory blocked (even with small amount of data).

There are many videos and helpful resources. Start with this one:

https://daxstudio.org/docs/features/traces/server-timings-trace/

Regards,
Oktay

Did I answer your question? Then please mark my post as the solution.

If I helped you, click on the Thumbs Up to give Kudos.