Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
stribor45
Post Prodigy
Post Prodigy

More efficient way to handle my queries

‎06-04-2024 05:12 AM

I have following tables

 

  • Table A - uses API call to fetch data for 2023
  • Table B - uses API call to fetch data for 2024
  • Calendar

Is there a way to not always call query for table A on refresh since the data is historical and I was just hoping to export all that data from Power Query and create new table and remove table A but exporting that table only exports 1000 rows since in Power Query you have to constantly sccroll down in order for more data to show in preview.

Labels:
Message 1 of 3
64 Views
0
1 ACCEPTED SOLUTION
Joe_Barry
Solution Specialist
Solution Specialist

‎06-04-2024 05:37 AM

Hi @stribor45 

 

Are you using the import mode when importing? If so, in Power Query right click on the 2023 query and deactivate Include in Report Refresh.

Joe_Barry_0-1717504611996.png

Hope this helps

Joe

View solution in original post

Message 2 of 3
47 Views
0
2 REPLIES 2
stribor45
Post Prodigy
Post Prodigy

‎06-04-2024 05:42 AM

That worked great thank you. I dont see those refreshing any more when I hit "Refresh all"

Message 3 of 3
44 Views
0
Joe_Barry
Solution Specialist
Solution Specialist

‎06-04-2024 05:37 AM

Hi @stribor45 

 

Are you using the import mode when importing? If so, in Power Query right click on the 2023 query and deactivate Include in Report Refresh.

Joe_Barry_0-1717504611996.png

Hope this helps

Joe

Message 2 of 3
48 Views
0

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All