Salesforce Data Refresh - Data Incomplete

[alex1300au]

Hello Power Bi Community,

I've created a report which pulls its information from Salesforce and Azure SQL Database (Free Trial). 
My free trial ended and the report stopped refreshing.

Today I've subscribed tto azure sql in order to refresh the data, however the report is not refreshing any data beyond the 6th of April.

I've created a new report extracting information solely through the salesforce API connector and created a simple dashboard and was able to get the accurate values, which included data past the 6th of april.

Has anybody ever experienced a similar issue and has a potential solution to this or knows how to approach this?

Any info is appreciated!

[Anonymous]

Is it possible you are hitting the dreaded "1M rows/hour per dataset" limit?

There's no error or message associated with it.   The refresh will just stop if you hit that limit.

[alex1300au]

No, there was no error.

If I pull up an old version of the file with outdated data, it will refresh but only populate the data up until the 6th of April.
I definitely do NOT have a filter set that would cause this.

[v-yulgu-msft]

Hi @alex1300au,

Did you get any error message when refreshing data?

Regards,

Yuliana Gu