When connecting to a Redshift database in AWS via an ODBC connection in PowerBI, the report will execute the queries already loaded into the report upon opening of the document (in the desktop version), or randomly (in the online version). If I load a new query into the report, often up to 5 copies of the single query will start to execute, in addition to unrelated queries from the report beginning to execute at the same time as well. This completely eats up the disk space and I/O operations, effectively tying up the database so nothing can actually execute. Is there a way to disable automatic execution of queries in both the Desktop and Online version of PowerBI? With the exception of a scheduled refresh and a manual query load, the report should not continually attempt to execute queries without request. Thank you!
2 Comments
- chassImpactful IndividualHello Alexandra, I have asked the gateway team to take a look at this. Thanks Chuck
- fbcideas_migusrNew MemberStatus added:Under Review
Recent ideas
F5 for presentation mode in POWER BI DESKTOP
F5 for presentation mode in POWER BI DESKTOP. In design time when we press F5 . 1) The canvas goes to fit to screen mode. 2) Visual headers will be hidden for visual components which set to hidden in...ndaneshi1 hour agoNew MemberNeeds Votes104Views3likes2CommentsExpose Card Visual Reference Values to DAX via SELECTEDREFERENCEVALUE() or similar
Description The new Card visual introduces Reference Values and Reference Labels, which are excellent for displaying targets, benchmarks, prior periods, and other contextual metrics alongside a KPI....SEMattis2 hours agoAdvocate IIINew2Views0likes0Comments