Forum Discussion
Get Data Source for Report
For every report period, I wrote queries that merged my parameter tables and filtered the results based on the reporting period. Then, I loaded all of those queries to a tab in Excel linked my "report headers" to those tables, and hid the tab. The conditional VBA statement to refresh my queries was updated to refresh the associated query that gets the source data names.
Thanks artemus for the reply.
I don't think I was very clear in my first message. I set the report for my colleagues to track sales by consumers in given months. The particular population of consumers that they are looking for has to be downloaded externally from a website. So, they get the lists and save to our shared drive. There are 12 datasets (one for each month of the year) that they look at, and that is joined to one source for sales. The report is set up (through list boxes and VBA) to update one report at a time, based on their selections. They get select any sales report from the given folder and any population, as a requirement of their request.
What I have right now are "report headers" in Excel that are linked to their selections (the parameters for the Power Query queries). The problem is, if they change the parameters and forget to refresh the query, the headers are not accurate as they will reflect the current parameter, but not what the query data source is. Do you know any way to pull the active data soruces? What I am looking for is the information that appears when you hover over a query in the Queries & Connections pane, as shown in the attached image.
Also, I apologize to everyone for using this Board in Power BI, but I haven't found a community for Power Query. My current organization will not allow me to download Power BI on my machine. :smileysad: