Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
wokka
Helper I
Helper I

How to store the filtered data in a permanent table

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.

4 REPLIES 4
v-xianjtan-msft
Community Support
Community Support

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.

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. 

 

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
Resolver II
Resolver II

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.

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.