Forum Discussion
Alternate solution for Enter data option in Power Query
Hi dufoq3
I am looking for a alternative methods or solution to eliminate manual data entry effort in Power Query(Enter data option), because there may be chances of errors or it is time consuming method(Enter data option). So seeking help for any other solutions in Power BI/Query in which we can make it dynamic or automatic process.
Note - Here I cant use Sharepoint method(Excel/CSV files)
Hi Vivek_Biradar ,
The key point is where does this data come from, and is it possible to read it and output it as an Execel in some way? e.g. using PowerQuery build-in connector, Python, WebApplication, etc. Do they select from some duplicate values (drop-down lists) and are there some constraints (data validation) on each column? These are all things to consider.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group