Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Currently I am doing API call to my application thru PowerQuery in xml format & getting responce in json.
Application I am using has another option to retrive data in Relax NG, is it supported by Power BI?
Here is code example from white paper:
default namespace = "" start = element call { attribute callerName { text }, attribute method { "customReportValues" }, element credentials { attribute instanceCode { text }, attribute login { text }, attribute locale { text }?, (attribute password { text } | attribute ticket{ text }) }, element report { attribute suppress-zeroes { "0" | "1" | "2" }?, #0=Nothing suppressed, 1=Suppress blank cells but not zeroes, 2=Suppress blank and zero cells(Default) attribute show-cell-notes { "0" | "1" }?, #0=Don't show cell notes(default), 1=show cell notes X-axis, # Axes must be specified in order X, Y, (optional) FILTER Y-axis, Filter-axis? } } X-axis = element axis { attribute type { "X" }, segment+ } Y-axis = element axis { attribute type { "Y" }, segment+ } Filter-axis = element axis { attribute type { "FILTER" }, segment } segment = element segment { (dimTier | levelTier | accTier | timeTier | versionTier | currencyTier | accAttrTier | levelAttrTier | dimAttrTier)+ } #Look up ids by calling the exportDimensions API dimTier = element tier { attribute type { "dim" }, attribute entity-id { xsd:integer }, #dimension id (stdRollup | stdEl)+ #stdRollup will allow for arbitrary rollups and stdEl will provide the dimension value id } #Look up ids by calling the exportLevels API levelTier = element tier { attribute type { "lvl" },
Solved! Go to Solution.
Hi @dstramilov,
As far as I know, we are not able to return Relax NG Compact format data in Power BI. As there is no OOTB function lists in Accessing data functions.
Best Regards,
Qiuyun Yu
Hi @dstramilov,
In Power BI desktop, we can call web APIs to get data and parse JSON. See:
How to call REST APIs and parse JSON with Power BI
how to connect my web api wtih Power BI Reports?
Best Regards,
Qiuyun Yu
@v-qiuyu-msft thank you for response. I am already getting data in json format from my data source.
My question is about alternative way to call data source using Relax NG Compact format in Power BI.
Hi @dstramilov,
As far as I know, we are not able to return Relax NG Compact format data in Power BI. As there is no OOTB function lists in Accessing data functions.
Best Regards,
Qiuyun Yu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.