cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Salesforce Data Refresh - Data Incomplete

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!




3 REPLIES 3
Advocate I
Advocate I

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.

Regular Visitor

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.

Microsoft
Microsoft

Hi @alex1300au,

 

Did you get any error message when refreshing data?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Microsoft Ignite

Microsoft Ignite with Arun Ulag

Featured Session: Drive Data Culture with Power BI- Vision, Strategy & Roadmap. Register here https://myignite.microsoft.com #MSIgnite #PowerPlatform #Power BI ​

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors