If you want to reuse this query without rebuilding it and you're absolutely sure that none of the data involved is private, you can disable the privacy firewall by clicking the Fast Combine …

I'm a little surprised that the text "Unexpected Error" is in English while the text of the exception message is in Swedish. Which language Power Query addin was installed, and how does it …

In one column of a table there is a value listed as #N/A, which is not accepted by power query. After changing this to something else, the query worked. Just a tip for me that some special …

So as long as fields contain a data it is fine, all my query is successfully loaded. But when i change a parameter in my web API URL and it happens that for particular query this field is …

I am running 32 bit Excel 2013 on Windows 7. I installed the most up to date version of power query (9/30/2015) today. Can anyone help me? I was really looking forward to using this …

I want to import a complete folder with PQ (no matter if in Excel or Power BI Desktop) containing only csv files. This folder is not fix, but is defined by a parameter. Scripting: letSource = …

May 5, 2017 · Based on your description, I suggest you use Power Query unpivot columns first and load to Excel, then based on the new data source create Pivot Chart.

I need to extract a table with selecting columns in power query dynamically.

The Tech Ed Power Point presentation states suggests that "Internal Power Query logic" affects folding, but I'm unclear what that means. Are the Text functions inhibiting query folding? If so, …

Hello,I'm importing multiple CSV files using get data from folder. Each file contains entirely different set of information and I'm not intending to combine them. Instead, I would like to …