Dynamic data source won't save in Power BI Service

Power Query
1

Hi, I have the following query that won’t save in Power BI service because it references a dynamic data source. I know I can use parameters but that has its limitations.

In the attached image there is sample output of the Xml layout and I want to know is there a way to make this non dynamic.

Thanks in advance.

let
Source = Xml.Tables(Web.Contents(“https://api.us.newsweaver.com/v2/thisweekthermo/publication/1027803/issues”)),
Navigation = Source{0}[issue],
#“Filtered rows” = Table.SelectRows(Navigation, each [approval_status] = “APPROVED”),
#“Added Custom” = Table.AddColumn(#“Filtered rows”, “Expanded XML”, each Xml.Tables(Web.Contents([#“Attribute:uri”])))
in
#“Added Custom”

image
image1242×892 63.5 KB

2

Hi @ysherriff ,

let    BaseUrl = "https://api.us.newsweaver.com/v2/thisweekthermo/publication/1027803/issues",    Source = Xml.Tables(Web.Contents(BaseUrl)),    Navigation = Source{0}[issue],    FilteredRows = Table.SelectRows(Navigation, each [approval_status] = "APPROVED"),    AddedCustom = Table.AddColumn(FilteredRows, "Expanded XML", each Xml.Tables(Web.Contents([Attribute:uri])))in    AddedCustom

For more advanced Power BI queries and to troubleshoot issues, you can utilize the tools available on the Data Mentor platform. This platform offers a variety of user-generated queries and guidance to help with your Power BI projects.

Kind regards,

Enterprise DNA Support Team