Forum Discussion
Dynamic Excel import data connect to sql queries, and mapping questions
I am trying to connect an excel import to my tables that are connected to sql server. However, how do I map it each time. Right now I have it so that there is a report. the user exports this report then goes back to excel to paste the data into excel because they need to manually input a text field which is on the excel spreadsheet which then can be categorized as a row in the powerbi report.
- Questions. HOw do I have a dynamic Index from the excel spreadsheet linking to the query. How do I map this dynamically.
-2. Is there anything special I need to do to my excel spreadsheet which is on the desktop? Powerquery etc?
2 Replies
Apologies, I am not understanding what you are trying to do or what needs to be dynamic. Can you try providing additional information or detail? Is the file name changing every time or ?
ok lets say i have the above query. which is pulling from sql except I added in the columns Category and subcategory custom in my query. I then created a report out using those fields out of the query and created an excel worksheet with those fields to link back to powerbi. it is just a normal excel workbook linked back to this table. I am not sure what fields I should be linking from excel to the above query. My goal is to have an excel spreadsheet so that the end user can manually type into the subcategory field and a category field in order to group things together in the report. I am not sure how to do this.
