Solved: Turning a large query into a static data table

thunderdome21 · ‎08-02-2021

I have a large query with several million rows that i'm looking to store as a static data table in Power Query. Can you please advise the best way to achieve this ?

mahoneypat · ‎08-02-2021

If that query is not needed by other queries, you can just right click on that query in the query editor and uncheck "Include in Refresh". That way, only your only tables will refresh.

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

mahoneypat · ‎08-02-2021

If that query is not needed by other queries, you can just right click on that query in the query editor and uncheck "Include in Refresh". That way, only your only tables will refresh.

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

Turning a large query into a static data table

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024