The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi,
from yesterday my custom visuals have some issues when calling the following functions (that woked before):
powerbi.data.SQExprBuilder.text(String(ANY_DATA))
dataLabelUtils.getLabelFormattedText(MEASURE, WIDTH, FORMAT_STRING, MEASURE_FORMATTER);
These issues affect the online version only, not the desktop (with the same code, of course).
Can you help me?
Solved! Go to Solution.
Looks like you are passing SQConstantExpr type value (as per powerbi.data.SQExprBuilder.text() call) where persistProperties method requires DataViewPropertyValue, so the following code works in both Desktop and Online:
SynopticPanelBySQLBI.prototype.persistData = function () { var properties = {}; properties.imageData = (this.data.imageData ? this.data.imageData : ''); //properties.imageData = (this.data.imageData ? powerbi.data.SQExprBuilder.text(String(this.data.imageData)) : ''); this.host.persistProperties({ merge: [{ objectName: 'general', selector: null, properties: properties, }] }); };
PS. It works in Desktop as changes in SQExprBuilder have not been reflected to Desktop yet. Using primitive type instead of SQExprBuilder is correct way here.
Thx!
Sergey
Looks like you are passing SQConstantExpr type value (as per powerbi.data.SQExprBuilder.text() call) where persistProperties method requires DataViewPropertyValue, so the following code works in both Desktop and Online:
SynopticPanelBySQLBI.prototype.persistData = function () { var properties = {}; properties.imageData = (this.data.imageData ? this.data.imageData : ''); //properties.imageData = (this.data.imageData ? powerbi.data.SQExprBuilder.text(String(this.data.imageData)) : ''); this.host.persistProperties({ merge: [{ objectName: 'general', selector: null, properties: properties, }] }); };
PS. It works in Desktop as changes in SQExprBuilder have not been reflected to Desktop yet. Using primitive type instead of SQExprBuilder is correct way here.
Thx!
Sergey
Thank you very much!
Is there a release date for the Power BI Desktop update that contains this fix?
Confirm this issue:
value SQConstantExpr {type: ValueType, value: "https://www.sqlbi.com/synopticdesign/wp-content/up…s/sites/251/2015/12/gallery_map_1449167366471.svg", valueEncoded: "'https://www.sqlbi.com/synopticdesign/wp-content/u…/sites/251/2015/12/gallery_map_1449167366471.svg'"} data.SQExprBuilder.text(value) data.js:3983 Uncaught TypeError: is not a function(…)