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...
Need Help
Show and Tell
Tips and Tricks
  • v-achippa's avatar
    v-achippa
    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

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

Hi rajendraongole1 ,

thank you for hinting so quickly.  Got it - half! 

Indeed there was a silly and useless filter in one table. Once deleted all Data was loaded correctly.

Only 2) I could not find. Power Query always switches back to TOP 1000. I am working with the GErman version, and I couldn't make out (nor google could) what the Option "Allow Data Preview to Auto-detect Column Types and Relationships for Entire Dataset" would be called in the German version.

Do you know? This is how it looks like:

 

  • rajendraongole1's avatar
    rajendraongole1
    Icon for Super User rankSuper User
    1 year ago

    Hi JKross  - This is visible in your screenshot under "Typenerkennung" (Type Recognition).

    1. Open Power Query Editor.

    2. Click on "Ansicht" (View) in the top menu.

    3. Locate "Spaltenprofilierung basierend auf" (Column profiling based on).

    4. Change it from "Top 1000 Zeilen" (Top 1000 Rows) to "Gesamter Datensatz" (Entire Dataset).

    This should prevent it from switching back to Top 1000.

     

    Hope this helps.