Forum Discussion

ErikSierra7's avatar
ErikSierra7
Frequent Visitor
1 year ago
Solved

SurveyMonkey connection

Hello all,   I have data that's imported into Power Bi using an access key from my survey in SurveyMonkey. Today I noticed my report failed to automatically update (after being successful for the l...
Need Help
  • SamsonTruong's avatar
    SamsonTruong
    1 year ago

    Hi ErikSierra7 ,

     

    Your assumption is correct and changes in the underlying schema/structure will break the report. To resolve this when it occurs, you can open the Power Query editor in the Power BI report and manually refresh the scehma for the changed table.

    If this helped, please mark it as the solution so others can benefit too. And if you found it useful, kudos are always appreciated.

    Thanks,

    Samson

     

    Connect with me on LinkedIn

    Check out my Blog

    Going to the European Microsoft Fabric Community Conference? Check out my Session

danextian's avatar
danextian
Super User
1 year ago

Hi ErikSierra7 

Either a column in the data source was renamed or deleted or some columns although aren't explicitly referenced in the query were renamed or removed. In such cases, the Power BI Service does not automatically perform a schema refresh. To resolve this, refresh the dataset in Power BI Desktop and then republish it.