Hi Team,
I am getting this failure mail in auto refresh option.(this error is not occuring during manual refresh) and this is not frequent it occurs once in a day
ERROR :
--------------------------------------------------------------------------------------------------------------------------------------
An error occurred while processing the data in the dataset.
Refresh failed:
Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.
The '<pii>Sub Vertical</pii>' column does not exist in the rowset.
---------------------------------------------------------------------------------------------------------------------------------------------
I have tried below steps :
1 - Open the report(s) in PBI Desktop and clear the cache (file...options and settings... options)
2 - Refresh the data in the desktop and save.
3 - Open PBI Online and remove the associated dataset(s). Note - you'll need to remove the reports from any content packs before you can remove the reports and data from the online service. Also you might want to make a note of the (failed) refresh schedule you had before doing this so you can recreate it exactly.
4 - Hop back to PBI Desktop and publish the report from PBI Desktop to Online
5 - Hop back to PBI Online and set the refresh schedule back up
6 - Add the reports back into any apps or content packs.
Still issue persists. When i do manual refresh this error is not occuring. Kindly help to fix this issue
