Hello. I am working with Power BI and PWA. I have been able to utilize the sample reports with great success. My question is more regarding adding new data into the datasource and having it be recognized by PowerBI. For example, in PWA I created an area (SharePoint list) similar to the way it has Risks and Issues, called 'Change Requests'. This has a handful of fields I would like to see. Adding into SharePoint was easy enough, but I can't seem to get it to show in the data in PowerBI. Looking into the premade connector from the sample reports, I am not sure how I might incorporate this into the data set. The only option I see when 'getting data' is asking for the PWA URL, nothing with extending that data beyond the sample data.
I was able to do Get Data on a SharePoint list and have it see it, however it was connected only to that one specific list. What I am after is more of a relative path. Each project would have its own Change Request list and would like to report on them all, not just a single one .
I am still learning this product so its likely I am missing something here. Any help is appreciated. Thanks
