Recently, I built a report to show [HH.MM] data label in Chart bar, found some bars data is incorrect with data source. For example, one of value is 7.23 from data source, however, it shows 7.299999996 in data label. I've checked backend and confirm the definition of the data column, even in dataset the data and column definition only show 2 decimals, but data lable is wrong for some bars. Changing column definition to show 1 decimal, the wrong lable jump to another bar which is very interesting. Here is an example:     After contacting support, they gave me an workaround to change data label property to configure "decimal" value from Auto to 2, and it shows correctly then.   However, why it picked up a wrong data from data source is a problem.   Post the issue here and hope it will help others to fix the similar issue. ... View more

I m having table from Azure SQL DB for listing user's  name and status like Ok,Alert,Danger.Also i just want to list the user's name and status only if their status was "Alert" or "Danger",for this in "Basic Filtering" i m having a filter condition "is not Ok".So the table only lists the user name and status only if its other than Ok and its working fine.But if the returning table contains only "Ok" as status then the Table visual not getting updated and  other visuals in my report properly updated.   Is visual wont update if the filtering fails.? ... View more

I have a SSAS Tabular model with multiple perspectives on a single table where not all measures are included in each perspective. The measures are grouped together using Display Folders. When connecting in PowerBI to SSAS Tabular model and selecting one of the perspectives, empty Display Folders appear in the field list even when the measures are not included in the perspective. Same result when tested against both 1103 & 1200 compatible models Connecting to the same perspective in Excel, the display folders with excluded measures do not appear in the field list. ... View more

Hi,   We are integrating new powerbi embedded azure service in our web application.   The usecase is to embed power bi dashboard/reports and customize them into web application and data source choosen is google analytics. I have created POC of it and able to embed dashboard/reports and its working fine.   The problem that I see is Data refreshment Issue for embedded reports/dashboard in the web application and also there is no Auto refresh configuration option exists, means if some data is updated in my google analytics account, those changes are not refelected in embedded reports and dashboard in web application until I do the data refersh manually(recreate a pbix and re-import it to workspace). Is this Problem solved?   I dont see even Schedule refresh option for newly launched powerbi embedded azure service.   Thanks, Kiran ... View more

Why do I create a new column in Project Online (Project Site), does not appear in the power bi? anyone can help me? Thanks ... View more

The SWITCH command is failing when being used with more than 10 levels in DirectQuery.  I sent a frown and received a response, so I'm guessing it's in the ICM, but I'd like to know status since all queries I have using SWITCH commands fail given more than 10 options. ... View more

  When using the Combine Binaries functioanlity, if you add a Duplicate Columns step to the Transform Sample Binary query then the output fails.         Note, this also happens if you add a custom function manually.     ... View more

I have a report that works like a charm in the desktop application but fails in the service. I am appending two large tables with monthly data and the result in the service is some data from the last day of the first month. I am assuming the operation times out or something like that. ... View more

Our data model has fairly long tables names.   Many windows in Power BI Desktop have limited real estate and thus truncate these table names. Because names often have the same prefix it's impossible to tell which table the selection applies to. Example: Manage Relationships and Manage Roles windows.   These windows have fixed external size and the internal panes also cannot be resized. So we are stuck with truncated table names.   Please allow external and/or internal resizing. ... View more

Hi,   I have created a Power BI Model using Power BI Desktop in Direct query mode. I upload it to Power BI web, everything is working.   Now my users dislike the performance of the direct query model. So I change the model to in memory mode, publish it. Everything is working...   except the GUI to setup the automated refresh and the connection to my gateway. So I cant refresh my model from the power bi web site.   and I cannot delete it, because I have online reports connected to this model. If I drop it, I'll drop the reports too, and I cant do it for now.   so how I can get the options to refresh my model?   Thanks. ... View more

when publishing reports from the desktop to the service that include the Azure Marketplace as a source (i.e. Date Table), credentials are invalid and cannot be updated preventing setting up a scheduled refresh or successfully completing a manual refresh. This error is only occuring for reports recently published to the service as reports with the Azure Marketplace as a source that were already published to the service and had an exisitng refresh schedule set have not been impacted. ... View more

I am using a slicer to filter a single visual on a page.  However, the data that is brought back include the day following the end of the slicer.  For example, I enter slicer dates that are between two days (i.e. 9/28/2015 and 12/21/2015).  However, the data in the visualization brings back date from 9/28/2015 - 12/22/2015.  I am seeing this across a number of my reports. ... View more

I cannot see my credentials to edit.  When trying to expand "Data Source Credentials" I get a loading wheel and then the dropdown expands but no data is visible.  See screenshot below showing that arrow is showing as expanded but no data is visible.  Has been this way for two days. Have attempted to use in Chrom and IE. ... View more

https://msdn.microsoft.com/en-us/library/mt253492.aspx   Per this site, the M function should return DateTime.LocalNow()equals 2013-03-08T14:22:42 in that format - but in PowerBI Query Editor, the month and day are returning single digit values for 1-9. This makes it very difficult to create functions that rely on aligning a datekey to an existing table based on the current date when refreshing. ... View more

hi when i try to export a tile to excel (both chrome and IE) the screen turns to semi-white and a black vertical line appears' as if a menu should pop. the compatabillity view and pop up blocker is enabled does anyone know what to do? thanks ... View more

Getting error "“Specified value has invalid CRLF characters. Parameter name: value”. "when i am trying to connect to a SharePOint on prem. ... View more