Forum Discussion
Inquiry: How to load data from Dataflow or PowerbI dataset to specific range in Excel
Hello there,
I am writing to ask on how to load data from Dataflow or PowerbI dataset to specific range in Excel
Here's the deal: I have already had cleanned data on my dataflow. However, the user needed specific format for the report in excel, which the user has created worksheet for me.
I tried to use power query, but the system created the new worksheet instead of input to the one I need.
the picture for the clearer idea:
You can see the A1:A10 will have fix value. The chaging value will be in D13 forward.
Thank you in advance.
Best regards,
Good day Book_Piramid,
If you click the drop-down beside the "Load" button there is an option "Load To...". If you select it a dialogue box appears which offers you an opportunity to choose where to place the data. I have included screen shots of both these steps below and of the result of the steps.
Hope this helps
2 Replies
Good day Book_Piramid,
If you click the drop-down beside the "Load" button there is an option "Load To...". If you select it a dialogue box appears which offers you an opportunity to choose where to place the data. I have included screen shots of both these steps below and of the result of the steps.
Hope this helps