Power Query Reviews & Product Details

Power query and clean data without making change in the source, it has clear step by step process, you can apply same data cleaning steps on some new set of data that have same architecture by just one click, by clicking refresh. You can things in the graphic interface and it turn it into code. Best thing is power query is same in excel and Power BI Review collected by and hosted on G2.com.

Some it gets stuck while doing a step or while refreshing data from source and it mostly in case where source is in the web i.e. Sharepoint URL Review collected by and hosted on G2.com.

Discover the game-changing capabilities of Power Query, a dynamic and flexible data manipulation tool integrated into Microsoft's renowned Power BI and Excel platforms. With its seamless connectivity to diverse data sources, you can effortlessly mold and refine your data to fit your analytics and reporting needs. Review collected by and hosted on G2.com.

Power Query combines seamlessly with Power BI and Excel, offering a cohesive experience for those utilizing these tools. Data manipulations carried out in Power Query can effortlessly be integrated into both Power BI reports and Excel spreadsheets Review collected by and hosted on G2.com.

Ease of use, as it provides an intuitive interface allowing users to perfirm complicated data transformation tasks with simple steps.

Also connectivity to a wide range of data sources, and the support it provides to a large spectrum of data transformations such as filtering, cleaning, merging, and custom column creation. Review collected by and hosted on G2.com.

For some users especially those with no prior data processing experience, Power Query can initially appear overwhelming due to the wide array of functions and capabilities. Review collected by and hosted on G2.com.

For these kinds of operations, Power Query offers an intuitive user interface that lets users conduct sophisticated data transformations without having to write sophisticated code. Review collected by and hosted on G2.com.

When errors occur during data transformation, debugging within Power Query might be challenging for users without a strong understanding of the tool. Review collected by and hosted on G2.com.

this is very easy excel sheet tool for enter all data in one software and 24/7 support system is very good Review collected by and hosted on G2.com.

this tool is littel bit hard to understand due to formulas and need to add more features Review collected by and hosted on G2.com.

Ease of use: Power Query provides an intuitive graphical interface that allows users to perform data transformation tasks without the need to write code.

Connectivity: It allows connection to a wide variety of data sources, including databases, CSV files, Excel files, online sources, and more.

Data transformation: Power Query allows a wide range of transformations on data, such as filtering, cleaning, table merging, and creating custom columns. Review collected by and hosted on G2.com.

Learning curve: For some users, especially those who have no prior experience in data processing, Power Query may initially seem overwhelming due to its wide range of functions and capabilities. Review collected by and hosted on G2.com.

It helps in Automating the tasks and can handle big data where Excel faces limitation. It is a solution oriented tool which help in Handling big data, automation and visualisation. Review collected by and hosted on G2.com.

There is no as such but It could have Simplicity in M-Language, It may have easier way to change the data path and It should not dependent on one system only. Review collected by and hosted on G2.com.

It is very ease to use, easy to search and easy to implement. Review collected by and hosted on G2.com.

I Didn't find any dislikes as such so far Review collected by and hosted on G2.com.

Power query is very helpful, you can transform the data to meet specific needs. It makes it easier and faster when woerking with it. Review collected by and hosted on G2.com.

If you have many excels windows open it will load slower. Review collected by and hosted on G2.com.

its data transformation capabilities, ease of use, and integration with various data sources, making it a powerful tool for data analysis Review collected by and hosted on G2.com.

Personally, it's just the learning curve. Review collected by and hosted on G2.com.