Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Vivek_Biradar
New Member

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 5
Joe_Barry
Super User
Super User

Hi @Vivek_Biradar 

 

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




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Learn about the Star Schema, it will solve many issues in Power BI!

Date tables help! Learn more



LinkedIn
Let's connect on LinkedIn


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.

OrderDateNameDetails
2Jun-23abcThis is a text
4Jul-24xyzThis 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.

 

dufoq3_0-1721805497765.png

 

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

 


Note: Check this link to learn how to use my query.
Check this link if you don't know how to provide sample data.

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)

Anonymous
Not applicable

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

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.