New Idea

Clicking items on the legend of a ribbon chart causes the entire ribbon chart to gray out. 

Instead, clicking an item in the legend should cause the selected item to be highlighted in the ribbon chart, while other categories should be grayed out.

 

- other charts are cross highlighted as expected.

- clicking other charts cross highlights the relevant part of the ribbon chart.

- clicking the ribbon chart highlights the appropriate category at the axis point selected.

 

 

 

Status: Needs Info

Reports are not working in the service

Status: Needs Info
by Steffen Frequent Visitor on ‎11-17-2017 05:15 AM

For the last 30 minutes it has not been possible to show reports in the service. They are just loading and never finishes. I have tried with reports from different sources, so the problem is in the Power BI Service. 

 

Can someone fix this ASAP? I'm based in northern europe.

Status: Needs Info

Data Source Credentials Not Updating

Status: Needs Info
by Topgunz786123 Occasional Visitor on ‎12-07-2017 12:31 PM

All of a sudden all of my automatic refreshes have been failing due a message "Your data source can't be refreshed because the credentials are invalid." Nothing has changed and I don't know why I am receiving this message. 

 

I click on Edit Credentials (Salesforce credentials) and unable to do so because now I'm receiving this message "Failed to update data source credentials: We're sorry, an error occurred during evaluation".

 

This was all working fine a couple of days ago and yesterday, I started running into the refresh issue. I have deleted my cache, cookies, etc. but I am unable to edit my Salesforce creditials.

 

Anyone have any ideas / thoughts?

 

Thank you!

 

 

Status: Needs Info

When I try to access the Relationships view of any dataset, I get this error message:

"Unhandled exception has occured in a component in your application.  If you click Continue, the application will ignore this error and attempt to continue.  The type initializer for 'System.Windows.Interop.OSVersionHelper' threw an exception."

 

After clicking continue or after just closing out of the error window, there are no further errors, but the Relationship view shows up as a blank page, showing none of the tables that I have imported. 

 

I tried uninstalling and reinstalling PowerBI and restarting my whole computer, but it did not help.  Suggestions for fixing this are most welcome!

 

 

Status: Needs Info

Relationship Display is not saving changes

Status: Needs Info
by DQuigg Frequent Visitor on ‎11-14-2017 11:11 AM

Is the relationships display in Desktop supposed to save the current position.  In other words, if I drag the hierarchy the way that I want, isn't it supposed to save it?  I seem to get constant issues where I clean up the display only to come back in and it is all hosed up.  Sometimes it seems to save it properly.  What am I missing? I had the one below all nicely laid out and then come back in later and it is all messed up per below.

 

Relationship Display.PNG

Status: Needs Info

Users starting reporting that their Analyze in Excel feature is not working anymore in Power BI. The organization is heavily dependent on the reports and due to this feature being stopped working, we are facing severe issues. 

Please help any MSFT member.

Regards
Naqash

Status: Needs Info

Today in latest Desktop I tried to switch to a new data source from Power BI Service but it is failing.

I'm getting this message: Couldn't retrieve the data for this visual. Please try again later.

 

Timestamp: 2017-11-09T10:43:24.4946361Z

Session ID: 73e95735-b4dd-4093-89dd-abf0d2245c37

Release: November 2017

Product Version: 2.52.4921.461 (PBIDesktop) (x64)

Error Message: Couldn't retrieve the data for this visual. Please try again later.

OS Version: Microsoft Windows NT 10.0.15063.0 (x64 pl-PL)

CLR Version: 4.7 or later [Release Number = 460798]

IE Version: 11.483.15063.0

User ID: 53e1cf81-d99c-4f6d-91d6-ac4f68bfd61a

Activity ID: null

Stack Trace:
System.InvalidOperationException: No session exists for database with ID:18975152-20a4-4cea-8098-5e56ce31abd2
at Microsoft.PowerBI.ReportingServicesHost.PowerViewHandler.GetActiveSession(String databaseID)
at Microsoft.PowerBI.ReportingServicesHost.ActiveReportingSessionConnectionPool.Get(IDataSourceInfo dataSourceInfo)
at Microsoft.DataShaping.Processing.QueryExecutionCommon.ConnectionWrapper.<>c__DisplayClass10_0.<<OpenConnection>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportingServicesHost.DataShapingTelemetryService.<RunInAsyncActivity>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.QueryExecutionCommon.ConnectionWrapper.<OpenConnection>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.QueryExecutionCommon.QueryExecutor`1.<RunQueryAsync>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.QueryExecution.QueryExecutionParallelStrategy.<RunQueriesAsync>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.QueryExecution.QueryExecutionManager.<>c__DisplayClass16_0.<<RunQueriesAsync>b__0>d.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportingServicesHost.DataShapingTelemetryService.<RunInAsyncActivity>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.QueryExecution.QueryExecutionManager.<RunQueriesAsync>d__16.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.DataShapeProcessor.<ExecuteQueryAndWriteResult>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.DataShaping.Processing.DataShapeProcessor.<ExecuteQueryAndWriteResult>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.DataShaping.Processing.DataShapeProcessor.<ExecuteQueryAndWriteResult>d__2.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Processing.DataShapeProcessor.<ProcessImpl>d__1.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportingServicesHost.DataShapingTelemetryService.<RunInAsyncActivity>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Engine.DataShapeProcessingHost.<InvokeProcessingAsync>d__4.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.DataShaping.Engine.DataShapeEngine.<ExecuteSemanticQueryAsyncImpl>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.ReportingServicesHost.DataShapingTelemetryService.<RunInAsyncActivity>d__10.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.DataShaping.Common.TaskUtils.WaitAndUnwrap(Task task)
at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ExecuteDataQueryWithDataShapeEngine(IQueryResultDataWriter queryResultDataWriter, EntityDataModel model, IConceptualSchema schema, DataQuery query, Int32 queryId, ServiceErrorStatusCode& serviceErrorStatusCode)
at Microsoft.PowerBI.ExploreHost.SemanticQuery.ExecuteSemanticQueryFlow.ProcessAndWriteSemanticQueryCommands(IQueryResultsWriter queryResultsWriter, ExecuteSemanticQueryRequest request, IConceptualSchema conceptualSchema, EntityDataModel model)

Status: Needs Info

I have two primary data sources in my reports - Salesforce and Workday which is via the built-in PowerBI CSV importer.

 

When I setup the PowerBI automatic refresh (in the web app), or via a manual refresh in the web app, all the reports fail to refresh and without any details.

 

In Desktop all the reports refresh all the time without issue.  (1) How do I get details of WHY things are failing? (2) Why does this work in Desktop and not after published/refreshing on app.powerbi.com?

 

Here is the latest example.

 

 

Message:The command has been canceled. Table: PowerBI: Projects(Non-Billable) w Financ.
Cluster URI:WABI-WEST-US-redirect.analysis.windows.net
Activity ID:c6d527e2-16a6-425b-8fd8-d83cdc7bc5af
Request ID:53f46564-797e-f825-02e9-b6870e0ac739
Time:2017-11-13 18:27:26Z
Status: Needs Info

as the link below

https://community.powerbi.com/t5/Desktop/Rendering-and-memory-usage-issues-in-desktop-and-power-bi/m...

 

After November mid update,this issue came back. when using drillthrough filter to jump to another page again and again,the memory keeps growing.

Status: Needs Info

This morning most of my installed Content Packs were no longer listed under My Workspace. When I go to Get Data and click Get It Now to reinstall, I receive an error "We couldn't import data from <report name>. Make sure you are entering information correctly." (Ex: We couldn't import data from Daily Booked Orders..."

 

One clue could be that there are two content packs that are unaffected by this issue, and the one thing that differentiates them is how they are permissioned. The missing content packs are permissioned via Office 365 groups, whereas one of the two unaffected content packs is published to Entire Organization, and the other has named individuals in the permissions list.

Status: Needs Info

Unable to connect excel with powerbi data

Status: Needs Info
by abhitiwa Frequent Visitor on ‎11-10-2017 03:40 AM

 

 

 

Hi

 

I have been facing issues with excel connection file (.odc) of PowerBI. I use the PowerBI data to analyse numbers on excel, and I have doing this for quite sometime now successfully. however, since past few weeks, I have been facing a connection issue, and have not been able to find the right solution. See screenshot of the error message I get once I enter my login credentials. I had installed PowerBI Publisher for excel a few days ago. Could this have caused any issue? I have unistalled it as well, but the issue still persists.

 

Any suggestions?

login_screen.jpegerror_msg.jpeg

 

 

 

Status: Needs Info

Unable to Publish to the service

Status: Needs Info
by Sruti_Praturi Visitor on ‎11-09-2017 11:11 PM

Hi,

 

Been trying to publish /republish a report to the service and get the following error 

Microsoft.Power bi.client.windows.services.powerBiWebException was thrown, any idea why this is happening?

 

Thanks,

Sruti

Status: Needs Info

Hello,

 

Our report - which is based on MY SQL Queries - seems to experience difficulties regarding the scheduled refresh. This is the error that we got back: 

If anyone can offer any advice or provide further information that would be highly appreciatedGateway Refresh ErrorGateway Refresh Error

Status: Needs Info

I though this was fixed in the last release and seemed to stopped happening after I downloaded the newest version. Now it is back and is a complete pain to deal with. Please fix this issue. Sign in issue_Ink_LI.jpg

 

 

 

 

Status: Needs Info

I struggle with performance when I use table container in my Power BI report there my source is SSAS (tabular or multi) same problem with both, and deploy it to Power BI Server. When I switch to another container, the performance is good. Only when I use Table container. I have good performance in Power BI desktop. The performance problem came when I go to Power BI portal an open a Report. The report will running and running when I open it. When I change from table to a graph container its work fine. Even when I use Multi-row card It’s work fine.

Status: Needs Info

Usage Metrics not populating

Status: Needs Info
by jmalone Regular Visitor on ‎10-19-2017 08:42 AM

I created a separate thread here on this same issue. Basically, my Usage Metrics reports show no data, except for "Total Dashboards in Organization"

 

I have confirmed with our O365 admin that the usage metrics feature is enabled. Also, others in my organization CAN see their usage metrics, so the issue may be isolated to my account?

 

 

UsageMetrics.png

Status: Needs Info

The drillthrough functionality seems to have caused one big issue for me.  I have multiple reports at a summary level with multiple slicers on each page and a detail level report with even more slicers.  I have setup the drillthrough functionality to work with my 'State' slicer.  When I use the drillthrough functionality to get to the detailed report, it works properly and filters my detailed report.  HOWEVER, the other pages in my report now have the state filter set as well, but there is NO way to remove it.  For example, I drilled on 'NY' and then all of my pages now only show NY as the only value in my list of values.  The only solution seems to be to remove or clear all of the other filters (even though all of them show 'All') on the page.  

 

I will try to replicate this, but I think there is a bug as this PBIX was working very well prior to implementing drillthrough.

Status: Needs Info

Slicer correctly filters matrix to an empty set in the July 2017 desktop version.

In the published web version, the sliced matrix incorrectly retains pre-slice contents, seems to ignore slicer.

Slicer field is in fact table.

Status: Needs Info

This morning, when I started Power BI Gateway - Personal, it failed with the error, "GWConf has stopped working A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available."  I uninstalled and re-installed the application but am still getting the same error.  The Personal gateway as worked flawlessly for weeks prior to today.  I'm not aware of any changes being made to my PC but I'm using a company computer and sometimes our IT department pushes out updates without prior notification.  Where do I begin looking for the cause of the failure? (I'm just a Power BI user, not a developer.)

Status: Needs Info

Image link: http://imgur.com/HqCky3f 

 

Hello,

 

I have pasted a link to the image above, I could not embed it for some reason.

 

I am pretty new to PowerBI, so be nice. I have loaded some geographical data against the UK using a postcode file on a map.

 

I get a yellow warning error bar at the bottom of the ESRI/ ARCGIS map that tells me: "Failed to Locate 23 Features".

 

I cannot work out how to interrogate, review or fix these 'features'.

 

It would be really helpful if error reporting was able to be scrutinised a lot more clearly for a novice like myself.

 

Any comments and support would be welcome. 

 

Many thanks,

AJ

 

 

Status: Needs Info