When aggregating a table column with nested tables, count returns the number of records in the nested tables. However, if a nested table is empty, 1 is returned instead of 0. The generated code for aggregation is for example: Table.AggregateTableColumn((Table1,"Tables", {{"Order",List.Count, "Count of Order"}}) As a workaround, List.Count can be replaced by List.NonNullCount. Strange enough and likewise, List.Count in combination with Table.TransformColumns, returns 0 for empty nested tables, e.g. Table.TransformColumns((Table1,{{"Tables", each List.Count(_[Order]), type number}}) ... View more

The remove duplicates in the power query doesn't remove all duplicates - different from the distinct function in powerpivot. I have more than millions of row. ... View more

If a table is created and called "Measures", PBI crashes. The solution should be to warn the user to not use this name, and prevent the system to use it. ... View more

Documentation here is incorrect: https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/ Specifically, the following listed limitations are no longer true: You cannot add calculated columns or tables You cannot change the data type of a column ... View more

It seems that when uploading my excel worksheet there are some missing columns. How? ... View more

I created a table appending two other table and after i duplicated this table 10 times, filtering differently. when i add a relation on the origin table, the relation also appears automatically in the 10 duplicate tables? Thks Chiara ... View more

This issue actually stems from an issue with UTC time not coming through from Salesforce properly. My workaround was to create a new column that adjusts for the time zone properly, and then assemble the date & correct time together into a new column. This works perfectly in desktop: CreatedDate_Final = (LeadAndOpportunities[CreatedDate_Day]) + (LeadAndOpportunities[CreatedTime]) but when published, that column is completely blank on web reports. CreatedDate_day is formatted from the imported "CreatedDate" from Salesforce, and CreatedTime is a date/time/timezone column that I'm just taking the "time" from. Any idea how to get the column to not be blank on the web? ... View more

Data set Scheduled refresh is happening at the time scheduled. Delay is happening. Any specific reason for this? ... View more

Add Power BI to our local SSRS server and not just in cloud servers! ... View more

DEP_GRP = IF(1<'2015_SUMMER_ONTIME'[DEP_DELAY]<=30,0,IF(31<'2015_SUMMER_ONTIME'[DEP_DELAY]<=60,1,IF(61<'2015_SUMMER_ONTIME'[DEP_DELAY]<=100,2,IF(101<'2015_SUMMER_ONTIME'[DEP_DELAY]<=200,3,IF('2015_SUMMER_ONTIME'[DEP_DELAY]>200,4,-1))))) ... View more

I am trying to create a conditional column in the Query Editor, but when I do so I can not type anything into the “New column name”, “Operator”, “Value”, “Output” or “Otherwise” fielded. This problem is only on my laptop and not on my desktop. I suspect that there is some OS configuration issue which is causing this, but I need some help on figuring it out. ... View more

Currently during refresh, when one data source is broken or missing, PowerBI will abandon the entire refresh and not load data from other sources that contain good data. There should be a way to un-check a data sources that is down or missing and allow the rest of the data to refresh. OR allow an option to 'skip and continue' data sources so that a long refresh process isn't stopped for one down service. ... View more

I would to create a calculated columns as difference between two columns, how can i make it? ... View more

Hi All, I've installed Power BI Desktop on a server with a local SQL Instance so we can publish to bi.com using the gateway. When trying to add a custom column and entering a column formula it states "The formula is incomplete" with every formula added, even just '="a"' shows as incomplete. Works fine in other instances of Desktop but they don't have line of sight of the SQL database. Tried clearing Cache Cleared App Data directory Re-installed Upgrade to latest version UAC is off (but is has been run as an admin anyway) Tried a new report with a completely different data set Based on the above it would suggest something environmental, anyone have any ideas? Its installed on Server 2012 R2 Standard with the Enterprise Gateway installed. ... View more

Summary: I have a error field that is a JSON (Nested). I use Transform->Parse->JSON to parse the column with the JSON. It works as expected but when it reaches a node where the field (details in the example below) is a LIST, then upon trying to expand that column (LIST), I get an error: DataFormat.Error: We reached the end of the buffer. Can you please tell me if there is a support to expand lists? { "status": "Failed", "error": { "code": "XYZ", "message": "Message_1'.", "details": [ { "code": "Timeout", "message": "Message_2." } ] } } ... View more

Able to create calculated measure but when I want to calculate mean of the calculated measure powerbi is throwing an error saying column value should be there to populate mean. Also when trying to create custom column with the same logic that I used to create custom measure getting the error “This expression refers to 'LocalDateTable_bf147677-e53c-4488-b893-a3226b14b05d[Date]', which has an error ... View more

Discussion here: http://community.powerbi.com/t5/Service/Calculated-column-being-cleared-when-loaded-to-powerbi-com/td-p/73694 It looks as if the Table.ExpandRecordColumn command is not working (in this instance at least) on the Service. There are no problems on the Desktop. ... View more

How to handle data redundancy in an Enterprise BI Self Service model, i.e., single version of truth. For example one user may have their own version of data on direct margin and other user may have the same. ... View more

DataFormat.Error: We couldn't convert to Number. Details: 2014219586-S ... View more