Forum Discussion
Alternate solution for Enter data option in Power Query
Hi All,
I am looking for multiple solutions for below query.
I want to avoid manual data entry in Power query. So looking for alternate solutions for Enter data option in Power query except excel file load.
I have a table created using manual data using Enter data option, I want to avoid the same. So please help me with the alternate solutions in detail, if possible with example.
5 Replies
Have you considered using SharePoint lists? You can create a form where yourself or users can entere and edit manually. You can connect to Power BI using the connector and the data will refresh automatically during Report refreshes. You can go a step further and create a Power App on top of the SharePoint list instead of the form, but you may need licenses for this.
Otherwise, excel is also a good option, depending on the complexity of what you need.
Joe
Hi Joe
Thanks for the quick reply.But in our organization we moved to GCP so we should not use Sharepoint, due to which we are restricted to use the excel files. As per the project requriment I created a table using Enter data option which has 4 columns sample as below.
Order Date Name Details 2 Jun-23 abc This is a text 4 Jul-24 xyz This is a text
Do we have any solution to create this table and make it dynamic in use to avoid entering the data manually using Enter data option or Excel.Hi Vivek_Biradar, I'm not sure what exactly do you need, but you can create table like this and you can replace any part of table with another query reference. For exmaple: you can replace "xyz" with another query name like LastPersonName to make it dynamic.
let Source = #table(type table[Order=Int64.Type, Date=text, Name=text, Details=text], { { 2, "Jun-23", "abc", "This is a text" }, { 4, "Jul-24", "xyz", "This is a text" } } ) in Source
