I've nearly 10 visuals in canvas, and the report is running under Snowflake Datawarehouse in DirectQuery mode. Few visuals have date parameter as their coordinates or in filter everything is working as anticipated in PowerBI Desktop version, but after publishing same to PowerBI service things got broken, All visuals with date columns (in filter or coordinates) not render with title error.
Cannot connect to the mashup data source. see error details for information.
Clicking error details shows following error
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
I previously read and understand that DirectQuery mode will not consider or apply Date and Time intelligence to date fields, that is ok but nowhere mentioned that Visuals with date fields will not work.
How to get Reports back now?
Uninstall either On-premise or Enterprise gateway from the Power BI server and try again.