Forum Discussion

JeffManley's avatar
JeffManley
Frequent Visitor
5 years ago

How do I pull data from a query to use in another Source's SQL statement pulling from Confluence

I'm pulling data from the PageContents table in Confluence using the Confluence Power BI Connector. The connector works great but running into a problem here since the SQL statement for the PageContents table requires that I specify the PageId:

 

= CdataConfluence.DataSource("CData Power BI Confluence", null, [Query="Select * from PageContents where PageId IN ('2997387628', '2997388229','2997388637','2997390219','3055714311','3066691719','3086090289')"])

 

The PageIds are located in the Pages table, which I pull into the model already. I was hoping to use the FILTER command to pull out all the PageIds that referred to the title starting with a month name dash two-digit year (i.e., July-21) then feed those associated PageIds into the SQL statement above.

 

Any ideas on how to implement this?

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    5 years ago

    JeffManley Definitely not via FILTER. You cannot reach data sources from DAX  (mostly).  You need to implement that logic in Power Query, and even there you are very likely to hit the formula firewall. Try it nevertheless.