Forum Discussion
Are the new features for query editing available in Power Query in Excel as well?
PowerQuery in Excel 2013 is available as add-in and These tools in Excel is considered as Version 1. Microsoft has fully focussed their BI efforts ion PowerBI as it serves as a complete ecosystem for Self-service BI. There is one exciting features called "Query Dependencies" added in recent release which would allow you to see any relations between two queries. Something like "alteryx".
Creating Parameters is also newly added feature in PowerBI and It would be thrilling for you to know that you can use list of values, another query or single values as Parameters. How Exciting! and All of these is completely free with 1GB of cloud space to upload your datamodels.
In Cloud, You can also use Analyze in Excel feature which will allow you to analyze your powerbi datamodel in Excel. Also, You can upload your powerpivot model in PowerBI Desktop.
So many things to do in PowerBI service and Desktop as well.
PowerBI is evolved from the PowerPivot in Excel( Personal BI) to the journey of corporate BI. Row level Security is one of the sexy feature of the PowerBI and would serve the purpose of the IT and Business Users as well.
Memorable Memberqshngv Excel and powerbi going separate ways is an incorrect interpretation. They are becoming much more closely aligned. Power query in 2016 is not a separate addin but a fully integrated part of excel. The functionality between powerbi and query editor in excel 2016 is nil. The difference in powerbi query editor you have and the excel addin is that the addin has been superceeded by powerbi. That is not true of the excel 2016 query editor.
If you have parametised values, you will not be able to do that in powerbi unless you pass the data into a powerpivot model as you have now and then use that model as a data source for powerbi. If there are a limited number of values that could be used as parameters, you maybe able to build them into a a model and use a slicer type function to change your report.
// If this is a solution please mark as such
Yeah, Power BI is going separate ways from Power Query in Excel...2013. Because 2013 is old now. 2016 is a different matter.