A Recent update to the online service has changed the way fields are displayed when using the drilling down all functionality. For my scenario I have distributors, reps and customers. When I use the drill down all function the chart now shows distributor rep customer all in one line. This is way too much text for a chart and we don't need this functionality for this chart. This issue doesn't happen in desktop but only when I publish to the web. Please help i'm getting multiple complaints on this topic. For more info and other users having similar issues you can see the ideas forum link below. The user zapppsr has a good recommendation I believe would be the best. http://community.powerbi.com/t5/Service/How-to-disable-the-automatic-inline-hierarchy/m-p/62180#M12153 ... View more

Here is my issue: I have Slicer data (multiple select option) to filter with Year and Month values. If I up to 8 values in the slicer, the graph looks decent if the increase the selection, the is not properly visible. I mean the thickness of the bars are becoming very thin. Can any body suggest why it is happening? Do I need to change any settings? Note: I did not change any filter setting they are all in default status. If I select 8 values from slicer, the graph looks decent, as below: If I select more than 8 values from the slicer, the graph bars are becoming when thin and not readable, as below: ... View more

NULL ... View more

i am not able to create a group,below is the error... Couldn't create the group Please try again later or contact support. If you contact support, please provide these details. Activity ID18351f75-7200-24fd-4a2e-9e38651d6aba Request ID46e9df11-bc10-1687-eceb-6c09b63ee4c1 Correlation IDaa3c4bf6-52f5-848b-545b-4dd5ed8cd590 Status code500 TimeThu Aug 25 2016 11:27:09 GMT+0530 (India Standard Time) Version13.0.1605.363 Cluster URIhttps://df-msit-scus.analysis.windows.net ... View more

Power BI cannot connect to SQL Azure servers as AAD users, only as SQL users. This puts major limitations on customers ability to properly manage access to their resources if they also want to create reports. ... View more

I am trying import Tabular model in PowerBI desktop model with "Import" option(not a Live). Data Keeps loading and never get complete. Just tried importing two tables and able to get through. In the backend model its creating cartition join with all the tables of imported tables. I thinks that’s reason it’s taking lot of time to import the data. Tabular model size is less than 100 MB Please suggest solution to this Problem. ... View more

After viewing a graph and then returning to the report, the tabs are missing. This is an issue on IE and Chrome. ... View more

When external user (Power BI por users) get the invitation and clicks the dashboard they receive "You dont have access to this dashboard". However in power BI the dashboard is available. The email link does not work . I have copy pasted the error message below ----------------------------------------------------------------------------------------- You don't have access to this dashboard There was an error processing the invitation Please try again later or contact support. If you contact support, please provide these details. Activity IDc9ef5a3c-2c96-422f-8e98-c9ba3cca7b57 TimeTue Aug 23 2016 16:40:24 GMT-0400 (Eastern Daylight Time) Correlation ID2d123c61-41d9-5176-3a53-6466805a791a Version13.0.1605.328 Cluster URIhttps://wabi-north-europe-redirect.analysis.windows.net/ Get help ... View more

With the KPI visual, the Goal value is not included in the rollup when the Indicator value is 0. If the table values are: Dept Indicator Goal HR 0 2.6 IT 4 0.7 Actng 5 6.5 TOTAL 9 9.8 The KPI shows an Indicator of 9; however, the Goal shows as 7.2 instead of 9.8. It ignores the Goal when the Indicator is 0. ... View more

Since the last update the format of percentages is broken. Everywhere we see something like: 75,40,94 % , while the correct value is 75,40 %. Setting 1 decimal isnt helping. Only 0 decimals is showing the correct percentage, but that is not an option. This happend at all our customers, in every existing dashboard/report that is connected to a tabular model through the Data Gateway. ... View more

Hi Guys, I'm having a problem connecting to a SSAS Cube through the Enterprise Gateway. This is my configuration: -Windows Server 2012 R2 -SqlServer Standard 2016 (evaluation) with latest CU -No Active Directory on-premise -Power BI Enterprise Gateway installed on the same machine This is what happens: -I can connect to the SSAS cube from Excel remotely (through a vpn) -I can connect to the gateway from Power BI service -I can create a Data Source pointing to the on-premise SSAS cube (I've mapped the online user with a local user whit accessing rights to te cube) -I can successfully perform a connection test -The data source is correctly listed in "Sql Server Analysis Srvices" But when I try to "get data" connecting to the data source, I get a very generic error in this form: Servers>MultidimensionalTestBi_02 Something went wrong. Technical details: Activity ID: ... Request ID: ... Date: ... Error test: System Error Cluster URI: ... Sql Server Profiler shows exactly the same error message, not very helpful I'd say. What am I doing wrong_ Thanks. ... View more

I have created roles in power bi desktop and published my pbix file. RLS works fine. But when I refresh the dataset , RLS doesn't work anymore. If I again republish the dataset it works fine but when we schedule a refresh and check then RLS doesn't work. The data gets refreshed but RLS doesn't work. Any known issue with this. ... View more

NULL ... View more

I wanted to create a new table but it was not available on the ribbon. How do I get this feature in PowerBI desktop working in my installation? I tried to follow the tutorial on creating a "New table". The other screen shot is from my installed version of PowerBI. My current desktop information is below: Version13.0.1605.328 Activity IDd291a912-6499-4c19-826b-400077b220ea ... 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 created a .PBIX file with a model and it has been working correctly for 3 months. Data sources are SQL Server 2014 and some Excel worksheets. After updating Power BI Desktop to the latest version, everytime I refresh the data it gives different results and they are always wrong. I have checked all the queries and the relations between tables and there have been no changes. I have also carried out tests on the data sources with SQL Management Studio and everything is correct. Everything would suggest that Power BI imports a different number of rows at each refresh (even when I press the refresh button every few seconds), but the table contains always the same (correct) number of rows. It seems that the error is an issue that involves only the Reports. What could be the reason? Do I have to fix some settings? ... View more

This may seem silly and may only be me, but I can't identify the visualization that I'm adding. In other words, the tool tip doesn't appear over the various (standard) visualizations, so when I add one to a dashboard, I don't know if I'm adding a slicer, or counter or whatever, so some sort of title bar above the property sheet identifying visualization type would be very helpful, so I don't have to try to figure out what icon is what. Using PowerBI Desktop 2.374464.602 32bit. Thanks! ... View more

The Cost field in the Power BI Service Content Pack does not appear as a measure when creating an ODC file using Analyze in Excel. ... View more

I am currently able to share my Dashboard with members within my organization. I type in their email, and the "Share" button changes from a dulled out gray to bright yellow. However, when I type in an external email, I get this popup in red: "One or more email addresses are outside of your organization." The Share button remains a dull gray and un-clickable. Please advise. ... View more