Forum Discussion

JKross's avatar
JKross
Icon for Helper I rankHelper I
1 year ago
Solved

How to refresh and load new Data in Model with applied Steps?

Dear community, I hope somebody can help, as I have something really odd, which is against everything I can find in the web and I do not know why. I have setup a rather complex PowerBI Model wi...
  • v-achippa's avatar
    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