Forum Discussion
How to refresh and load new Data in Model with applied Steps?
- 1 year ago
Hi JKross,
Thank you for reaching out to Microsoft Fabric Community.
Thank you rajendraongole1 for the prompt response
Open Power BI Desktop > Click on File > Options and settings, then click on Options.
Go to Global > Data Load > Ensure that Background Data refresh is enabled.If you want to always limit the number of rows fetched for example, if you have a query that fetches more than 1000 rows, you can modify your query to limit the data.
In Power Query Editor, apply a filter step to only load the top 1000 rows of your data:
Go to Home > Transform Data to open Power Query Editor.
Select the table/query you want to adjust.
Use the Keep Top Rows option in the Reduce Rows section of the Home tab.
Set the value to 1000.
Apply and close to keep only the top 1000 rows in your model.If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Hi rajendraongole1 ;
TRied it: here is how my view tab "Ansicht" looks like:
The Option comes again only at the bottom left corner (like in any other tab view)
I changed again all relevant tables to All Data, but when I go back it's again Top 1000 only.
Any other idea, where I can find it?