New Idea

Hi,

 

I have a line chart visualizing daily average values for price. I also have a funnel chart where each bar represents the weekly average of the price. When pressing a bar on the funnel chart, the line chart neatly zooms to that week, or at least it does on the desktop app. 

 

When the report is published on the Power BI website in an App or viewed inside a workspace, the same functionality somehow brakes. Now the zoomed line chart zooms too much, so that large parts of the line are out of bounds, or it plots some points on the charts at wrong places randomly in relation to the Y-axis. E.g. an individual datapoint with a value of 52usd is plotted at 45usd in the zoomed version of the chart. 

 

I can't figure out what is going wrong, as everything is working perfectly on the desktop app.

Anyone got an idea or is this a bug?

Hello,

 

I am getting an error "Access to the resource is forbidden" when trying to access Microsoft Graph in Power BI Desktop report.

Microsoft Graph URL is https://graph.microsoft.com/v1.0/devices

I am logging in using Organization Account.

I have Global Admin role in the tenant.

 

The report was working normally for months, but stopped since yesterday.

I even tried creating new one - same result.

Accessing the same URL from Graph Explorer works fine.

 

What could actually impact this kind of error?

Hierarchy Slicer do not work on IE11

Status: New
by MPeinado Regular Visitor on ‎05-09-2018 03:03 AM

Hierarchy Slicer do not work on IE11.  Yesterday,it worked fine...

??

 

??1.jpg

PBI Desktop Error

Status: New
by dharland Regular Visitor on ‎06-06-2018 07:21 AM

Recently, I started receiving an error when opening a report (that I've been working with for months) in PBI Desktop. This morning I updated to the latest version but the error continues to occur. I've submitted the issues numerous times through the default mechanism in PBI Desktop but have not heard anything from Microsoft.

 

Feedback Type:
Frown (Error)

JS Error Message:
Cannot read property 'enableSDKLogging' of null

Error Message:
An error occurred while rendering the report.

Stack Trace:
TypeError: Cannot read property 'enableSDKLogging' of null
at n._instrumentAuthCall (https://www.bing.com/rms/MapCoreBundle/cj,nj/d1fc78f3/60f87994.js?bu=rms+answers+MapsSDK+AnonymousBe...)
at n._logServiceSuccessCallback (https://www.bing.com/rms/MapCoreBundle/cj,nj/d1fc78f3/60f87994.js?bu=rms+answers+MapsSDK+AnonymousBe...)
at _logServiceResponse._credentials._hasValidCredentials (https://www.bing.com/rms/MapCoreBundle/cj,nj/d1fc78f3/60f87994.js?bu=rms+answers+MapsSDK+AnonymousBe...)
at https://www.bing.com/rms/MapCoreBundle/cj,nj/d1fc78f3/60f87994.js?bu=rms+answers+MapsSDK+AnonymousBe...
at https://www.bing.com/mapspreview/sdk/mapcontrol?mkt=en-US&ur=US&c=en-US&onscriptload=globalMapContro...
at ZoneDelegate.invokeTask (ms-pbi://pbi.microsoft.com/minerva/scripts/desktop.js:13140:189)
at Zone.runTask (ms-pbi://pbi.microsoft.com/minerva/scripts/desktop.js:13022:63)
at ZoneTask.invokeTask (ms-pbi://pbi.microsoft.com/minerva/scripts/desktop.js:13180:63)
at ZoneTask.options.isUsingGlobalCallback.invoke (ms-pbi://pbi.microsoft.com/minerva/scripts/desktop.js:13174:56)
at data.args.(anonymous function) (ms-pbi://pbi.microsoft.com/minerva/scripts/desktop.js:13895:41)

Stack Trace Message:
An error occurred while rendering the report.

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception)
at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3.<SendAndMarshalExceptions>b__0(Object null)
at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)
at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)
at System.Delegate.DynamicInvokeImpl(Object[] args)
at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)
at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)
at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__FabricatedMethod8(IWindowHandle )
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass7.<HandleExceptionsWithNestedTasks>b__6()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)

 

 

 

PBI-error-1.pngPBI-error-2.png

 

 

 

 

Not able to open PBI file (even new blank one)

Status: New
by JorisVoorn Frequent Visitor on ‎03-16-2018 04:51 AM

After instalation of PBI Desktop update (March) I am not ableto open any PBI file (even new blank one). I tried to repair PBI desktop via Control PAnel, reinstall back to rpevious verison, change x64 bit to x32 bit version, but nothing worked. 

 

Error messages varies based on PBI file that i am trying to open, below is one of the error logs that PBI shown me after PBI failed. Sometimes is error message only announcement that PBIDesktop is not able to load data modle and nothing else (what is kinda strange when this error message appear during opening of blank PBI file...

 

Feedback Type:
Frown (Error)

Timestamp:
2018-03-16T11:34:23.0617108Z

Local Time:
2018-03-16T12:34:23.0617108+01:00

Session ID:
a986f59a-fb3f-477b-852e-f5c8a5ebf5a6

Release:
March 2018

Product Version:
2.56.5023.942 (PBIDesktop) (x64)

Error Message:
Couldn't load the model schema.

OS Version:
Microsoft Windows NT 10.0.16299.0 (x64 en-US)

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

Peak Virtual Memory:
35.5 GB

Private Memory:
1.08 GB

Peak Working Set:
1.06 GB

IE Version:
11.309.16299.0

User ID:
f140123a-0dfa-4434-8f7c-e25e9a0abb0a

Workbook Package Info:
1* - en-US, Query Groups: 5, fastCombine: Enabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\v-pavsch\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot360440546.zip

Performance Trace Logs:
C:\Users\v-pavsch\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_AdobeAnalytics
PBI_qnaExplore
PBI_variationUIChange
PBI_customVisualsGallery
PBI_canvasTooltips

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

 

Last month we created a PBI report with this tooltip preview feature and published to services, Which was working fine at that time. Whenever we did mouse over to that visual it responded to that filters applied to that visual.

 

From yesterday it's not responding to that filters applied to that visual (only in services), In PBI desktop its woking fine still.

 

PBI Desktop:

 

PBI Desktop.PNG

 

PBI Services:

 

PBI Services.PNG

 

Is there any issue with services or do we need to enable any setting in services, Without doing anything same feature was working fine earlier.

 

Thanks,

Dinesh J.

GDPR Personal Data message popup

Status: New
by belvoir Member on ‎05-25-2018 01:54 AM

Hi,

 

Tried to post an idea to https://ideas.powerbi.com/forums/265200-power-bi-ideas  and got a popup message saying "Action Required" - which is about consent to store personal data. Clearly a GDPR issue in the UK as compliance is required from today.

 

It has two options and you need to choose one of them. Except you can't - there's no checkbox, the Submit is inactive and the whole thing is greyed out.

 

Looks like someone hasn't tested this live....!

 

Anyone else in the UK getting this error today?

 

 

Line chart data labels are shown incorrectly

Status: New
by Spetter Occasional Visitor on ‎06-03-2018 04:00 AM

Hi

 

I have 2 measures shown on a line chart but the data labels from one measure are sometimes shown as a data label from the other measure and vice versa. See this image for an example. Sometimes it helps if I make the graph larger but on some graphs even making it very large doesn't help + I just don't have the space on a dashboard to make it bigger. Could this please be fixed?

 

http://i63.tinypic.com/2e232gj.jpg

 

 

Friendly greets

Error while exporting to Power point

Status: New
by parijatmalla Visitor on ‎05-02-2018 10:28 AM
I am getting following error on exporting to Power Point.
 
Image 2018-05-02-13-26-59.jpg

Power BI service performance issue

Status: New
by maniagarwalla Frequent Visitor on ‎04-03-2018 09:40 AM

We as an organization are using Power BI for several reports and dashboards and have 70+ Pro licenses.

We have noticed that the performance on the service has been very bad sporadically and specially today.

For eg. reports are taking long times to load, filters on reports are not working - all widgets keep loading, also getting errors sometimes.

 

We need help from Power BI support , but not sure about this escalation channel.

Please help asap.

Hi all

We recently updated our report server from the March 2018 build to April (Build 15.0.2.402)

After the upgrade, we aren't able to view any of our saved PBIX files in our portal, getting the error 'unable to load folder contents'.

The upgrade seemed to work fine with no error messages.
However looking in the report server LogFiles folder, we found the attached log file which concerned us, especially the below.

 

ERROR|6|Aborting SQL batch sccript! Error executing SQL batch script at entry
------------
CREATE PROCEDURE [dbo].[GetAllProperties]

 ...
|FATAL|6|Database upgrade failed!!  The database may now be in an inconsistent state.| 

 

Could you please advise?
Thanks

 

 

2018-05-16 12:01:16.2047|INFO|1|File Logger created: C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\RSManagement_2018_05_16_12_01_16.log - level Info, will roll at 32 Mb, process id 11668
2018-05-16 12:01:16.3133|INFO|1|CFG : Dumper.path = [..\LogFiles\] (env)
2018-05-16 12:01:16.3133|INFO|1|CFG : Name = [] (env)
2018-05-16 12:01:16.3133|INFO|1|CFG : Dumper.flags = [SendToWatson, AllThreads, AllMemory] (env)
2018-05-16 12:01:16.3133|INFO|1|CFG : Dumper.preventIfContains = [Microsoft.BIServer.HostingEnvironment.Exceptions.TrustedProcessTokenExpiredException] (env)
2018-05-16 12:01:16.3133|INFO|1|Do not dump on: Microsoft.BIServer.HostingEnvironment.Exceptions.TrustedProcessTokenExpiredException
2018-05-16 12:01:16.3133|INFO|1|CFG : listenerUrl = [http://+:8083/] (env)
2018-05-16 12:01:16.3133|INFO|1|CFG : rsConfigFilePath = [..\ReportServer\rsreportserver.config] (env)
2018-05-16 12:01:16.3290|INFO|1|SKU: Power BI Report Server - Evaluation
2018-05-16 12:01:16.4227|INFO|1|The web server needs to run elevated
2018-05-16 12:01:16.4227|INFO|1|Web Server is running.
2018-05-16 12:01:16.7661|INFO|6|Creating default Global MeterCollector| RequestID = s_bd19dfa8-cd03-45ff-a34d-e4679807b9b3
2018-05-16 12:01:16.7661|INFO|6|CFG : DatabaseQueryTimeout = [300] (env)
2018-05-16 12:01:16.7661|INFO|6|CFG : SqlBatchTimeoutMinutes = [30] (default)
2018-05-16 12:01:16.8991|INFO|6|Database Version Detection: Trivial Upgrade:
Db Version = 15.0.2.378
Code Version = 15.0.2.402
Resulted in status UpgradeRequired| RequestID = s_bd19dfa8-cd03-45ff-a34d-e4679807b9b3
2018-05-16 12:01:16.8991|INFO|6|Upgrading ReportServerPBITest database to version 15.0.2.402 hash 82A232C71E4B6F0383517F51F757B13005FCA16BAA125C1DE5A0A5A6952D7322| RequestID = s_bd19dfa8-cd03-45ff-a34d-e4679807b9b3
2018-05-16 12:01:22.8855|ERROR|6|Aborting SQL batch sccript! Error executing SQL batch script at entry
------------
CREATE PROCEDURE [dbo].[GetAllProperties]
@Path nvarchar (425),
@EditSessionID varchar(32) = NULL,
@OwnerSid as varbinary(85) = NULL,
@OwnerName as nvarchar(260) = NULL,
@AuthType int
AS
BEGIN

DECLARE @OwnerID uniqueidentifier
if(@EditSessionID is not null)
BEGIN
EXEC GetUserID @OwnerSid, @OwnerName, @AuthType, @OwnerID OUTPUT
END

select
iif( Catalog.LinkSourceID is null, Catalog.Property, Linked.Property) as Property,
Catalog.Description,
Catalog.Type,
Catalog.ContentSize,
Catalog.ItemID,
C.UserName,
C.UserName,
Catalog.CreationDate,
M.UserName,
M.UserName,
Catalog.ModifiedDate,
Catalog.MimeType,
Catalog.ExecutionTime,
SecData.NtSecDescPrimary,
Catalog.LinkSourceID,
Catalog.Hidden,
Catalog.ExecutionFlag,
Catalog.SnapshotLimit,
Catalog.Name,
Catalog.SubType,
Catalog.ComponentID,
Catalog.ParentID
FROM ExtendedCatalog(@OwnerID, @Path, @EditSessionID) Catalog
INNER JOIN Users C ON Catalog.CreatedByID = C.UserID
INNER JOIN Users M ON Catalog.ModifiedByID = M.UserID
LEFT OUTER JOIN SecData ON Catalog.PolicyID = SecData.PolicyID AND SecData.AuthType = @AuthType
LEFT OUTER JOIN Catalog Linked ON Linked.ItemID = Catalog.LinkSourceID
END
------------
| RequestID = s_bd19dfa8-cd03-45ff-a34d-e4679807b9b3 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'is'.
vid System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
vid System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
vid System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
vid System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
vid System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
vid System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
vid Microsoft.BIServer.HostingEnvironment.Storage.MeteredSqlConnection.ExecuteBatchScript(String script, TimeSpan individualCommandTimeout)
ClientConnectionId:6fe5b85f-0edd-44e9-8b26-f5dab8efbb72
Error Number:156,State:1,Class:15
2018-05-16 12:01:22.8855|FATAL|6|Database upgrade failed!! The database may now be in an inconsistent state.| RequestID = s_bd19dfa8-cd03-45ff-a34d-e4679807b9b3 System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'is'.
vid System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
vid System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
vid System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
vid System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
vid System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
vid System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
vid Microsoft.BIServer.HostingEnvironment.Storage.MeteredSqlConnection.ExecuteBatchScript(String script, TimeSpan individualCommandTimeout)
vid Microsoft.BIServer.Management.WebApi.DatabaseUpgrade.DatabaseUpgrader.GetStatusAndUpdateIfRequired(ISqlAccess sqlAccess)
ClientConnectionId:6fe5b85f-0edd-44e9-8b26-f5dab8efbb72
Error Number:156,State:1,Class:15

 

 

2018-05-16 12_40_32-Home - Power BI Report Server.png

Publishing to Power BI service never ends

Status: New
by Mo-PHAT Frequent Visitor on ‎05-15-2018 07:02 PM

Hi,

 

I just did the May Update and now when I try to publish to the Power BI Service it just displays the plublishing screen forever.

 

When I look in the service it is actually published and works fine but the desktop application never finishes and needs to be forced to close via the task manager.

 

I am signed in when I try to publish.

 

Thanks

Kirsty

Report page tooltip not refreshing

Status: New
by bhavesh-jadav Frequent Visitor on ‎05-28-2018 05:02 AM

Hello there,

 

I am having problem with report page tooltip. The problem is that it does not refersh data immediately after I change slicer value. See example below.

When I select VEN from slicer I see value as 142,115 and 27 on tooltip. see screen shot below.

When I select SEA and the without doing any action I again hover on bar to see tooltip. I see the same values (see screen shot below). This goes away when I rehover on the bar and then I can see the correct value.

Why after changing slicer value, if I hover on the same bar that I hovered on before changing the slicer vlaue, I see last slicer selection related value?

 

For example Language = Nederlands

 

Edit option is missing with 100% Zoom Level

Capture.PNG

 

This is actually hiding underneath, when the zoom level is 90% it shows up

Capture2.PNG

 

This is happening with lot of languages. 

Hello,

I have a Dropdown slicer (built-in visual, not custom) on my page and I've created two bookmarks.

When I switch to another bookmark (using image with action) - then suddenly my slicer switches to a List instead of Dropdown.

And it stays like this even if I return to an original bookmark.

Looks like a bug - please fix

Thank you

Michael

Cancellation occurred when sending or receiving a request.

Status: New
by hugo6262 Visitor ‎01-11-2018 08:09 AM - edited ‎01-11-2018 08:11 AM

Hello, Im unable to refresh one of my reports, the gateway is ok, and in power BI destkop refreshes properly. can you help me out, I get this message:

Last refresh failed: Thu Jan 11 2018 16:29:15 GMT+0100 (Romance Standard Time) 
Cancellation occurred when sending or receiving a request

Cluster URI:WABI-EUROPE-NORTH-B-redirect.analysis.windows.net
Activity ID:c21669ce-c606-4dc0-93d6-66fc6578519d
Request ID:3a01ab7b-abe3-e1d6-dbf1-2fc09cde3c1c
Time:2018-01-11 15:29:15Z

 

Hi

 

In the 'Selected' status of the button, the font options set for selectes status is shown only as long as you the left mouse button is in the clicked state, the minute we leave the mouse button, the button status shows the hover/default status. In effect, the button does not display the 'selected' status font schemes.

 

Regards

 

Gopa KumarButton issue.jpg

Desktop ribbon becomes unresponsive

Status: New
by Veles Regular Visitor on ‎04-09-2018 01:47 AM

I've been getting issues for a while now where the ribbon in desktop will become unresponsive. The only buttons that work are those in the quick access toolbar.

 

This has happened on several versions that have been released. Currently on 2.57.5068.501 64-bit (April 2018).

 

Doesn't seem to be any consistency in how it happens. Best guess is when Query Editor is closed or possibly when a refresh is done.

 

Perhaps the UI is not being renabled properly when the refresh dialogue box is closed.

It works correctly if you are using filters within the regular Power BI service window......the "Reset to default" button will light up once you make some changes. Clicking it will return everything to normal. 

 

However if you are using working in full screen mode and make some changes to filters and then return to the normal view, the "Reset to default" button is not lit up and you have to manually go and clear each of the filters.

 

Can you please enable the reset to default button to work after exiting full screen mode.  Optionally can you please add it to full screen mode so that users don't need to exit to do it.

 

Thanks

 

Regards, David.

After installing the March 2018 release of Power BI Report Server, I am unable to include URL Parameters to filter reports.  Without parameters, the report loads and reders just fine.  Adding URL Parameters to the web address, causes the page load but without any report content.

 

URL Parameters were working prior to the March 2018 update.

Idea Statuses