Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

PBI Service Automatic Refresh

Hello, I'm having an issue at an automatic refresh on a premium capacity workspace.

 

The Dashboard is pulling data from an API with credentials already set on desktop and service place, running with a On-Premise Data Gateway (Personal Mode) in a server.

 

The desktop version is getting new records from the API but when the automatic refresh runs, it only capture the old information without adding the new records/rows.

 

There is no error on the refresh process, the proxy settings are okey and not causing any issue.

 

Any clue? Thanks,

 

Pablo.

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi, Anonymous 

    Limit the amount of data you import, which you can do by going to Power Query Editor in Power BI Desktop and removing any unnecessary columns.
    You can also consider increasing the memory of the premium capacity of the hosted dataset. Try refreshing large datasets during off-peak hours.
    You can solve your problem by limiting the amount of data you import or by otherwise optimizing the dataset.
    If you're using Power BI Premium, you might want to consider increasing the memory allocation for the Premium capacity that hosts this dataset. Or delete unnecessary Power BI files, datasets from your workspace.

    You can check the following links:

    Solved: Refresh failed in premium capacity workspace due t... - Microsoft Fabric Community

     

    Troubleshoot refresh scenarios - Power BI | Microsoft Learn

     

    How to Get Your Question Answered Quickly

    Best Regards

    Yongkang Hua

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.