Relax NG Compact format

[dstramilov]

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" },

[v-qiuyu-msft]

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

[dstramilov]

@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.

[v-qiuyu-msft · Accepted 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