PowerBI and Data from SharePoint lists across multiple sites

ercwebdev sorry for missing your message. I'm having trouble digging up an old version of my report which used this method but it sounds to me like there may be an issue with some of the references in your table... is it possible one of the URLs is pointing back to the parent site rather than a subsite?

I was able to get this to work in Power BI desktop using the method I outlined in my previous post, however when I published the report, Power BI Service and Dataflows both wouldn't refresh and I wasn't able to find a way to make it work (the error was due to the dynamic nature of my query). If you can live with refreshing it locally, it should work as expected. I had to restructure the way I was approaching my problem and moved as much of the data to the parent site as possible, making the subsites much less useful.