New Idea

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

app.powerbi.com is down in the north europe

Status: New
by jenrom Occasional Visitor on ‎11-09-2017 11:13 PM

When loading the app.powerbi.com page we are getting 500 errors for multiple http calls

 

Below you can find the console log from chrome debugger0

 

(index):163 GET https://wabi-north-europe-redirect.analysis.windows.net/powerbi/metadata/app 500 (Internal Server Error)
doInitialMetadataLoad @ (index):163
(anonymous) @ (index):163
web.bundle.min.js:26 GET https://wabi-north-europe-redirect.analysis.windows.net/metadata/notifications/summary?take=100 500 (Internal Server Error)

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

Hi all.

From yesturday users outside of organisation see null dashboards with only the Q&A section. Any suggestions how I can fix this?

 

image.png

Status: Accepted

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

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

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

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

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

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

Cannot delete broken tiles from Dashboard

Status: Accepted
by mshparber Established Member on ‎10-22-2017 01:39 PM

Hello,

I've changed some calculated fields in my model, so some of my tiles broke with Error:

"Unrecognized fields in this visual". But that's ok, I was expecting this.

I want to replace them with new tiles from the report.

But now I CANOT DELETE those tiles!!! No option for delete.

Just "Go to report" or "Export".

Please Help, my dashboard is full of these!

Thank you

Michael

DASHBOARD.JPG

 

Status: Accepted

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

Hi everyone,

 

Since the latest PBI service update the Chiclet visual is not working within published reports. The issue has been raised in the Community forum but yet to be resolved:

 

https://community.powerbi.com/t5/Service/Slicer-works-on-Desktop-but-not-well-Online/m-p/242274/high...

 

From initial testig this is what we have found:

 - various versions of the visual work within PBI Desktop (also variety of versions) but whenever published doesn't work as it should

 - when published online the visual doesn't refresh the other affected visuals (instead it either does nothing, displays the wrong information, or requires a different visual to be clicked before it is refreshed)

 - only under one circumstance were we able to get it published correctly (that was to an account we created years ago in O365 - all other accounts, including new accounts created in O365 today, fail to load the visual properly)

 - the visual works fine within the Windows 10 PBI App

 - the issue (that we have kown about) has been ongoing for the past few days - corresponding with the latets PBI Service update

 

Any help would be much appreciated as we have over 50+ reports using this visual and it's quite an embarassing to have to explain to users/customers we're not sure why or when the issue can be fixed.

 

Thanks

 

Jarrod

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

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

Redshift Connectivity to PBI Service

Status: New
by fbachmann Frequent Visitor ‎11-08-2017 05:52 AM - edited ‎11-08-2017 06:41 AM

Hello, 

 

We are running into the problem that our redshift cluster, that is not open to all IP addresses, can't be reached from PowerBI Service as it is using multiple IP addresses that are also changing on weekly basis. But it can't be the idea of having this Redshift cluster open to all connections. For a company like us this is absolutly not acceptable. Is there any solution for this issue. 

PS: connection on or Redshift Staging Cluster where we allow all connection works perfectly fine... 

 

Best,

 

Florian 

Hi All,

 

We have a Dashboard that pulls from 2 different reports that has been up and working fine for awhile.  But as of this morning we're suddenly seeing strange issues.  Here's what we observe:

 

- The main issue is that the Tiles are all blank (no error, just empty as in the first screenshot below)

- The dashboard says "Refreshing" in the top left and has been like that for hours

- The underlying reports do load properly, and if you pin a new Tile, then that new Tile works fine

- The original, blank tiles cannot be deleted from Dashboard.  When you click the menu, there simply isn't an option to delete it anymore. (see second screenshot)

- Clicking "Refresh Dashboard Tiles" does not force them to load

 

This is our main Dashboard and it would be less than ideal to have to rebuild it completely.  Hoping someone has seen this before and knows a solution...?

 

Thanks

 

Capture11.PNG

 

Capture12.PNG

Status: Delivered

The stacked column charts stopped working in existing dashboards and reports.  all other reports, grids etc seem to be working fine.  Datasource is SSAS MD cube.  I have confirmed that there is data at the intersection in the cube that is included in the reports.  Report was created from dataset online and not from desktop power bi. 

 

 

Status: Accepted