The online service seems to be slow this afternoon. It was working fine till now. The slicers and tables, whihc instanntly lods, now take lot of time.    Do look it. ... View more

I am using line chart visual, all properties are doing grt. But i am facing one issue. I have all my column values in rounded format upto 2 decimal point. Still chart is displaying few values like 0.1399999999999999 for value 0.14 which is not exact value. Acc to report requirement i have to set auto for Display and Decimal properties of it.                   ... View more

Hi,   I have found a bug with the Power BI website and the Personal Gateway refreshing a data source that is querying a web service.   Defect Summary:   Querying a web service with Power BI Desktop works fine with 'Ignore Privacy Levels' turned on. Enabling Fast Combine in the Personal Gateway does not allow the Power BI website to refresh the data source. It gives the following error:    [Unable to combine data] Section1/QueryName/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.   Expected Behaviour:   Turning Fast Combine on in the Personal Gateway should ignore privacy levels and allow the Power BI website to refresh the data source, just how it works in Power BI Desktop.   Details:   The web service requires authentication with a logon method that generates a key. This key is then passed to a seperate method that requests data from the web service.   I have implemented this using Web.Contents with a subquery that queries the login method. This approach works fine in Power BI Desktop by telling it to Ignore Privacy Levels. (i.e Fast Combine).   I am passing the full web service query using [Relative Path] and [Query] within the options field. This allows me to set up a refresh in the Power BI website using anonymous authentication.   Next, I published the .pbix to the Power BI website and tell it to Connect Directly. It failed with the following error: [Unable to combine data] Section1/QueryName/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.   I did some more reading and saw that the Power BI Personal Gateway allowed me to turn on fast combine https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-enable-fast-combine/   I followed these instructions (nb: they need updating as the folder path to the xml file is wrong). I also had to add a dummy data connection to an on premesis sql data source so I could tell the data source to refresh using the Personal Gateway. However, I still got the same error message even with Fast Combine enabled. This is unexpected as the Fast Combine setting should allow the web service query to work.           ... View more

Everytime I open a certain power BI desktop file not all the data in the reports load because of an error in one of my calculated columns - The error in the lookupvalue function doesnt recoginize a certain table and field in my caclulation. To correct it I remove the table / field name and replace it with the same exact value, the cacluation passes the syntax checks and all my reports update and I save it.  The next time I come into the file I have to do it again. There has been no changes to the data, or reports and it worked for months. This seem to happen after the last upgrade ,  Any Ideas ?    Thanks You,  Brett        ... View more

I have a table visualization to which I added a new column. I want the column to be in a specific place. In my report it looks good. However, when exporting the data, the new column is placed on the far right. The issue is in the PowerBI service (online). It seems to work well in the Desktop version. ... View more

When I go to a workspace and try to add a new user as an 11th admin, it will add that user as a member.  If I try to change a user to be the 11th admin, it throws an error.  See attached.  ... View more

It's getting rather annoying to be notified every few clicks that my trial has expired.  I've clicked the X to dismiss the notification about 15 times now...   I'm not using any pro features. How can I get PowerBI to stop displaying the notification? ... View more

Hi,    We shared a dashboard with the non-pro users, and untill last week, the users were able to access the dashboard without any issues.    As of today, the users are able to access the dashboard when they click on the WebLink, however, when the user wants to go back to the dashboard using the click or Alt + Left Arrow, it returns an error.    The dashboard only has imported data, and no live query linked to it.       Thanks, Vijay ... View more

The number in source excel is 0.2, but in graph it shows as 0.19999999999999998. I tried rounding the number in query editor, it didnt help. It helps to format the number with set number of decimal places, but in my model I appreciate the option of having it automatic as some values have decimals and some are in thousants.   Screenshot:   ... View more

Something went wrong. Unable to save the report Please try again later or contact support. If you contact support, please provide these details. Activity IDfce168e0-0420-c7be-baad-a05a1239785f Request IDc5cfc38c-4e07-7ab1-5c03-58aa87ee69b3 Correlation ID4d4b43f8-1adf-04d9-cb6b-5cad524eabdb TimeTue Jan 31 2017 00:27:14 GMT-0700 (Mountain Standard Time) Version13.0.1700.1082 Cluster URIhttps://wabi-us-north-central-redirect.analysis.windows.net ... View more

I am trying to print a report from PowerBI service. As per instructions, I followed these steps - Click on Report Name -> File -> Print Current Report page. However, a mysteriously a line comes in the print preview which is actually not on the report and it also gets printed. I tried many times but this happens each and every time with all the report and their pages. Could you please help me understand what the underlying issue is? I have attached the screenshot. Using Google Chrome version 55.0.2883.87 m (64-bit). Blank Report Page Line appears on same report when printing ... View more

I am working to try and resolve an issue regarding external sharing with our Customers.  About two weeks ago my external customers have commented that they are no longer able to see the model in the data elements on PowerBI.com.   I have a hunch that the renew pro subscription prompt is not showing for them, and they are unable to load the model because of that. I have not heard if this was indeed an issue, or has been fixed.   I also opened a trouble ticket and worked with an engineer at MSFT (Anthany Neslon).  I was unable to get to him an invite email (even tho it shared successfully from PBI.COM).  Today, I got my own 'external' domain email, and was also unsuccessful in sharing with myself.  The invite indicates it sent just fine, but I never receive the email on my other domain.     Is there work being done on this feature?    Thanks, ... View more

I'm not sure if this was requested or not yet as a new feature request. its hard to find all the topics, as there are many ways to explain this.   When creating a table of Pie chart where the values quick calc are percentage of total, and you want to filter on some of the legends and not all of them - all there to be a filter option to select either to base the percentage calculation on the total # of items in the set, or to base the percentage on the Items selected.   Currently, it only bases the percentage on the selection. So, if I filter and only select 1 legend item, it will display 100% since that is the only item selected. It would be nice that it displayed its true percentage of the total dataset.    Rob ... View more

Hello BI team, I have encountered a major glitch that needs attention. When trying to input a multi-line SQL query under the "advanced options" section of ODBC (under "Get Data" >>> "Other" section), the open window will not allow the user to scroll back up in order to minimize the "advanced options" so that the "OK" button can be pressed and the ODBC query submitted for data processing and pulling. This virtually makes pulling ODBC data via SQL query currently unusable. If you could address this as soon as you get a chance that would be great...thanks! See screensot attached for a visual of the problem.   ... View more

In the Query Editor, if you select a date or datetimezone type column and choose Add Column - Date - Day - Start of Day or End of Day, the result gets an incompatible data type datetime, instead of date or datetimezone.   To make things worse: the results are still visible in the Query Editor, but the data won't load to the data model. (See also issue: http://community.powerbi.com/t5/Issues/Table-AddColumn-and-Table-DuplicateColumn-may-display-invalid/idi-p/120314).   Example of created code (Start of Day for a date column): = Table.AddColumn(SampleData, "StartOfDay", each Date.StartOfDay([Date1]), type datetime)   The cause of the issue is with the data type datetime that is supplied as parameter columnType with Table.AddColumn, while the actual data is date or datetimezone. Likewise: for other "Start of..." and "End of..". options (Year, Month, Quarter, Week) on the Add Column menu, the generated code differs according to the datatype of the selected column. My suggestion is to do the same with Start of Day and End of Day. ... View more

Issue moved from the old issue site (and slightly refined)   If you supply a columnType with Table.AddColumn or Table.DuplicateColumn (e.g. Byte.Type), then the Query Editor will also display values that are out of range for the Data Type. E.g. for Data Type Byte, values >255 are still displayed in the Query Editor, but they won't load to the table when the query is applied, meaning: leaving loaded fields empty in the data model.   This differs from Table.TransformColumnTypes which will result in an Expression.Error when data is out of range. My suggestion would be to use the same apporach for Table.AddColumn and Table.DuplicateColumn.   Note: even some automatically created code suffers from this; I'll raise a separate issue for that.   ... View more

Have signed up, but then cannot get our NAV linked to PowerBI so I  can hand off even a basic demo - following the setup guide closely   When I try to add the NAV data source (with basic auth), this is what I get:   Failed to update data source credentials. Activity ID:   Request ID: 834b75ae-0079-5ba1-86df-5a6fb88b981f Status code: 400 Time: Mon Jan 30 2017 12:22:47 GMT+1100 (AUS Eastern Daylight Time) Version: 13.0.1700.1082 Cluster URI: https://wabi-australia-southeast-redirect.analysis.windows.net   I am fairly certain my ODATA creds are correct because I can go into chrome, enter the ODATA URL, input the credentials and see the XML data being returned.  The format of the string also seems correct for the example provided in the connection screens.   given my odata info seems solid, is this a system bug?   I have seen posts about other error 400 issues, but they also usually list an extra line of supporting data which I am not seeing.   Also in the setup guide, this error is not mentioned in the troubleshooting section which also makes me think it is not an issue with the URL or credentials, or else I would be getting a different error.   So is this a bug, or should I be looking elsewhere for an issue.   Where to from here?   I think this is my only support channel unless I sign up?  If so, then there is a bit of a catch22 going on there!     The setup guide I am referencing is:   https://powerbi.microsoft.com/en-us/documentation/powerbi-content-pack-microsoft-dynamics-nav/ Thanks Andrew ... View more

Something really annoying that needs to be addressed - In Power BI Desktop when I go to publish a report I sometimes get asked to sign in before publishing... The only issue is that a dialoug box says "Working on it" thats in front of the sign in box... SO I CANT SIGN IN AND I HAVE TO USE THE TASK MANAGER TO KILL THE PROCESS AND THEN RESTART...   One would say to make sure your logged in - but it says my name in the top right corner leading me to believe that Im still logged in... But It must time out after 10-15 minutes because im not longer logged in. ... View more

See bottom of page: https://app.powerbi.com/visuals/info#submit Link reads: Learn more about creating and submitting visuals Current URL of link: http://go.microsoft.com/fwlink/?LinkID=671709   Instead navigates to page: https://powerbi.microsoft.com/en-us/support/   If this is intended, it's not clear that I will find help here for creating and submitting custom visuals. I expect to be taken to a page specifically about the topic. Changing the link to read: "Find support for creating and submitting visuals" might make this link a little more acceptable. ... View more