Power BI with Microsoft Forms. Deleted a question and now automatic refresh gives error

[zarul_zaabah]

Hi everyone,

I built a simple Power BI Dashboard with Microsoft Forms as the method for data collection. i would then publish the data to Power BI Dashboard. Yesterday, i deleted a question in the Microsoft Forms (already collected 14 responses) and this would eventually change the table structure.

i received an error as below when the system tried to automatic refresh. does anyone know how to fix this without creating a new Power BI dashboard? how do i reroute the data source to a new table in my template dashboard with ease?

Processing error: The column 'EVENT DESCRIPTION' of the table wasn't found.
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: 2b326e71-3a9f-41c0-b3e4-1fe49d18e676
Request ID: 2f12f98c-0617-4e1b-81a6-759a7d0fd5a7
Time: 2023-02-28 16:11:28Z

thanks for your help!

Zarul Zaabah

[rajulshah]

@zarul_zaabah ,

I think you would need to refresh the report on Power BI Desktop and then publish it to Power BI Service.