Hello All ,
Any help in the following is appreciated. Thanks in advance.
I have a requirement as below:
- I wrote a SQL query using power query and fetched 15 records.
- Now I need to build a pivot on the data I got from query but the problem is I need to filter 15 records(as per user requirement) and final data set that I need to pivot has only 10 records.
-When I load the data into data model , all 15 records are getting loaded instead of 10.
- I want a macro or some way to load only filtered data into data mode i.e. If I run the macro now , only 10 records should be loaded into data model.
Thank you
Any help in the following is appreciated. Thanks in advance.
I have a requirement as below:
- I wrote a SQL query using power query and fetched 15 records.
- Now I need to build a pivot on the data I got from query but the problem is I need to filter 15 records(as per user requirement) and final data set that I need to pivot has only 10 records.
-When I load the data into data model , all 15 records are getting loaded instead of 10.
- I want a macro or some way to load only filtered data into data mode i.e. If I run the macro now , only 10 records should be loaded into data model.
Thank you