Closed bmvalente closed 2 hours ago
The issue you're experiencing with dynamic queries not allowing refreshing data in the published report might be due to the data sources for your queries not supporting refresh. This is indicated in the error message you're seeing.
However, it's important to note that the ADO Dashboard can be published in the PowerBI online service with auto refresh enabled. This is because dynamic queries are not being done directly from the PowerBI file, meaning that it can be published and consumed from the PowerBI online service.
If you're still experiencing problems, please refer to the Troubleshooting Guide and the Github closed issues for potential solutions.
Here are the relationship models for Governance and Infrastructure for your reference:
Governance:
Infrastructure:
Reference: GitHub Content
Pre-requirements
What dashboard are you reporting an issue on?
Infrastructure
What happened?
Dynamic queries don't allow refreshing data in published report, I don't remember it being like that last time I configured it.
Steps to reproduce
Create report on PBI desktop, Publish and try to configure auto refresh for data.
Additional context