It would be helpful to be able to set up a distribution list of those to send refresh failure notifications to. Currently, only the owner receives an email, but we have several administrators that require notification when certain reports fail.
53 Comments
- melissa2New MemberWhen a calculation error exists somewhere in the model, a refresh can't be performed. Suggestions: (a) Check calculations first before refreshing tables to speed up the failure getting returned. (b) Improve error messages so they are much more clear - currently they are very generic. (c) Show a warning indicator at table level if any column has an error, which will save time from expanding every single table to hunt for issues.
- maupalekNew MemberAuto-refresh failures only 'alerts' the owner & not the team working on the reports.
AnonymousNot applicablewe had a frustrating issue today. For some reason, 2 of our tables had a relation defined between them (not sure how it happened. All tables are generated based on Kusto queries, and there is no logical relation between them), and today all our refresh attempts failed (Locally and in the dashboard). There was no indication that the reason for failure was due to that relation. After refreshing all graphs one by one (I have about 30), I saw the reason for the failure: Today, the column which was chosen as the FK received 2 similar values. Why didn’t I get this notification when I refreshed the entire report? The failure reason I got was very vague (General DB failure message which I saw only when I refreshed locally. Far away from the detailed message I got when I refreshed the specific graph). I removed the relation and that resolved the issue . If possible - I suggest you’ll add the detailed failure reason to the Refresh failure reasons- powerbi29New MemberI only get an email notifying that a refresh failed for the entries in the 'refresh history' where there is 'failure message' for a failed refresh. please send refresh failure email whenever the status is 'failed'
- billmanh
Advocate I
Many errors contain the value {FieldValue}. This implies that there is a space where an error message could have been added, but was not. Error messages should be a required part of the feature. - fbcideas_migusrNew MemberInclude a link in the body of the Refresh Failed email notification to the actual dataset that failed in order to save time trying to figure out which workspace a dataset resides.
- bryanca8881New MemberOn the refresh failed email, you really need to both include a link to the failed dataset (would save much time) and include what the workspace name is that the dataset came from. I'm in 50 workspaces and it's a guessing game sometimes... :/
- hymie_hoNew MemberPlease vote for this other version of the same request: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19965952-enhance-refresh-failed-email-notification-to-inclu
- hymie_hoNew MemberYES!!! We have Dev, Test, UAT, and Production environments. A message that "refresh failed" without indicating which workspace is extremely aggravating. Almost as bad as "Publish succeeded" without indicating which workspace it was just successfully published to. WHEREVER YOU MENTION THE NAME OF A PROJECT, YOU MUST ALWAYS MENTION THE GROUP WORKSPACE TOO.
- fbcideas_migusrNew MemberHey! As an interim solution, I blogged about this. A nice PowerShell work around to retry and 'alerts' on failed dataset refreshes. https://www.sqlshack.com/manage-power-bi-dataset-refresh-failures/
Recent ideas
Power Query Parameter create/use when connecting to a dataflow
In power query when you connect to a table in a dataflow there are no options to create or use a parameter for that dataflow. When connecting to SQL there is an option when setting up the connection ...ben_holmes43 minutes agoNew MemberNeed Clarification192Views3likes1CommentParameterize Dataflow Gen2 data source connection
Allow the Dataflow Gen2 data source connection GUID to be parameterized and stored in a Variable Library. This would allow the same Dataflow to use different connections depending on the workspace/e...frithjof_v50 minutes agoCommunity ChampionNeeds Votes34Views2likes1CommentExpose Power Query as a Standalone Runtime and Command-Line Interface (CLI)
Summary Power Query has evolved into one of Microsoft's most powerful data transformation technologies and is now used across Excel, Power BI, Fabric, Dataflows, Power Platform, and other products. ...juansgr_53 minutes agoNew MemberAbandoned18Views0likes2CommentsExpose User Prompt and Agent Response Logs for Fabric Data Agents
Idea: As an engineer responsible for managing and improving Microsoft Fabric Data Agents, I currently have no way to view how users are interacting with the agents I’ve built. While it’s likely that...JoshuaPitzer2 hours agoAdvocate INew1.2KViews26likes2CommentsImprove relationship visualisation in Model View for large semantic models.
When working with complex models containing many fact and dimension tables, relationship lines frequently cross and overlap, making lineage difficult to follow. A useful enhancement would be to allo...jcheeseaos3 hours agoNew MemberNew6Views0likes0Comments