New Idea

Date filler issue

Status: New
by Idan_liniad Visitor yesterday

Last week our team start notice wired behavior of date filter.

we mainly work with the 'advanced filtering' for dates filtering to analyze data on an hourly level. when trying to pick the first date range it won't select the date that was picked in the calendar pop-up, but when selecting the second date range it's updating the first date range.

 

We tried using Chrome, Firefox and Edge - they all have the same behavior.

it's for any selected date, not to a specific range.

please click on the next link to see the issue record as GIF

Power BI Service Down

Status: New
by darranm Frequent Visitor on ‎12-08-2017 12:38 AM

Hi,

 

Is the Power BI Service down for anyone else?

 

UK, 8:37am

 

Power BI Error.PNG

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

Greetings all,

 

After the update on 11.12.2017 we have noticed that the advanced filter for dates has stopped working correctly.

 

 

Basic and relative date Report Filter works fine, however, Advanced date filter does not work correctly anymore. You can open the advanced filter, and the calendar, however, you cannot select anything... What you select in the first calendar goes to the second date box. However, if you select something in the second box, it doesn't go anywhere. 

 

I believe you understand the criticality of this bug, and I'm tired of answering the phone.

 

The problem can be reproduced by all our users, testers and developers, both on powerbi.com and embedded reports (premium). It does not affect any filters in the PowerBI desktop.

 

If you need more info, give an e-mail (or if you have access to contact details, contact me directly) and I'll send you a video to demonstrate the bug and try to help you understand the situation better if needed.

Status: Delivered

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

I have a set of reports that use an MDX SSAS cube data source with defined hierarchies.  The reports include multiple matrix visuals, some table visuals and a few other visuals.  The reports function correctly in Power BI Desktop; however, when the report is published to the service the matrix visuals fail to render.  The visual can be switched to a table and it will display results.

Status: Accepted

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

image.pngimage.pngimage.pngimage.pngMy visuals are not displaying the negative values all the visualisations. I assume it is because the y axis does not want to show negative values. I cant find any options in the format editter which help with this problem. 

The values chosen are simply input into a column of a new table that is not connected to any other tables and therefore there is no model to consider. The date column is only used to display the data in the visualisation.

line style missing in October update

Status: Accepted
by magsod Member on ‎10-12-2017 12:57 AM

Could not find any previous posted issue for this but in the forum multiple people have reported this issue and I'm also one of those that rely on this feature. link to community

 

Please take a look at this!

 

Br,

Magnus

 

Status: Accepted

Need for a scroll bar in Selection pane

Status: Accepted
by AxelPrunier Frequent Visitor on ‎10-11-2017 07:52 AM

Hi! 

 

I want to use the Selection pane to manage my visuals on a page. However, I use a lot of visuals (especially text boxes), and some of them at the bottom are not accessible via the Selection pane as there is no way to scroll down. 

 

Can you please fix this?

 

Cheers,

Axel

 

Capture.PNG

 

Status: Accepted

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

The Attribute Slicers works fine in PowerBI Desktop, no warnings, published w/o issue, but the Attribute Slicers do NOT function in the published reports.  The slicers worked fine w/previous publications.

Status: Accepted

We have a report in PBI service containing lots of matrixes. The report uses SSAS live connection as a source

They have fields in the rows, no fields in the colums and ofcourse some values.

 

If I download the report and open it in PBI desktop (Version: 2.51.4885.701 64-bit (October 2017)) the report works fine.

 

They worked fine last thursday. Today I get a complaint of the enduser that the report doesn't show data anymore!

I only get the matrix working if I add a field of the columns. 

 

Has there been an update on the matrix visual? Please fix!

 

Status: Accepted

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

SSAS tabular model switch issue

Status: Accepted
by pcavagnoli Occasional Visitor ‎11-13-2017 07:09 AM - edited ‎11-13-2017 07:10 AM

Hi,

we defined a report with Power BI Desktop with a Live connection toa tabular model (SSAS 2016).

When we move it from development to pre-production we usually change the SSAS tabular connection using edit queries.

We try to do this with the latest version of Power BI Desktop (Nov 17)  but all the visuals used appear signed with an X (no object found). The same works fine with the previous versions.

We suppose this is a bug.

Status: Accepted

Email Subscriptions - Showing No Data

Status: Delivered
by stetran Frequent Visitor on ‎11-24-2017 06:44 AM

Hi,

 

I have email subscriptions set up that send dashboards out to me on a daily basis. Occasionally, seemingly on random days, parts of the dashboards within the emailed image show no data when there is data in the data model, and the correct data is displayed when viewing the dashboard within Power BI itself.

 

Is anyone experiencing the same issue?

 

No data shown in the email, but the correct data can be seen within Power BINo data shown in the email, but the correct data can be seen within Power BI

 

Thanks,
Steven

 

Status: Delivered

So, this is logged over in ideas.powerbi.com. However, It's really a bug that can cause problems with report integrity and trust of users for reporting. Table visualizations cannot display duplicate rows. This is with summarization turned off for every field on the table, which is a separate pitfall. In SQL terms, the table visualization acts like a UNION, but it should act as a UNION ALL.

 

The workaround for the present is to do as advised in the forums, which is to add a unique column to the table visualization and then shrink the column width in order to hide it. In one case recently, however, I had to add an index to my query and then hide that column (with word wrap on, this hack also had the effect of resizing my rows to accommodate the wrapped but hidden index field). My users would like to see, for example, that a check detail has two line items for exactly $51. And I would prefer not to have to build workarounds. 

 

 

Hi team,

 

In new release verson of Power BI desltop Version: 2.51.4885.543 64-bit (October 2017). There is no Line style (a Shape feature) of Line chart which is added in Aug 2017 release. Could you please kindly check it?

1.PNG

 

 

 

Status: Accepted

Query Editor Window Bug

Status: Accepted
by jameslo30 Member on ‎10-16-2017 02:08 AM

Bug in PowerBI Desktop Version: 2.51.4885.701 64-bit (October 2017)

 

When you single click a query in the "Queries" selector on the left hand side, it thinks you want to move the query up or down to re-order.

This did not happen in the previous version.

 

Issue.png

Status: Accepted