New Idea

Hi,

 

I want to use a PNG as background with size 1600/900 for a dashboard. This image has only outer borders (see image). When I select this image in PBI Desktop as a background image, it does not show up on the canvas. Changing the image fit does not change this behaviour. It is probably there, but just seems out of bounds. After publishing the dashboard, the image shows perfectly in the PBI Service. Is it me failing or Power BI Desktop?

 

Bye,

Rudi

 

HPE-back.png

Status: Accepted

Yesterday, all my datasets were refreshing just fine but today nothing happens.

- The automatic refresh hasn't done anything.

- When I press "Refresh now", I get a "popup" saying "preparing refresh" for a split second and then nothing happens.

 

The only way to update the data is to refresh the Desktop version and then upload it. 

 

I have datasets connection to an on-premises database and one connecting to a sharepoint site.

- The on-premises connection usually works perfect, but now nothing happens.

- The sharepoint connection usually brings up an error,  if I try to refresh, but now nothing happens (I just tried it this time as a test, as it usually doesn't work automatically).

 

Can you please help troublefinding - It seems like an issue on you online portal somehow.

 

Thanks in advance.

 

// Tommy

Status: Delivered

I've been working on a data set for a few weeks that maps the top 10 records by zip code in the Map vizualization. This data set was working up until yesterday (2/13/2017). Today, 2/14, the power bi embedded version no longer maps the zip code data.

 

I downloaded the Feb 2017 power bi desktop update, and now I have the same problem in the desktop version. I went back to the January update - but the mapping there is also not working.

 

Did something break in Power BI? Or bing maps?

Please help, as this problem will completely derail a customer initiative.

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

Hello,

 

From today( 14/02/2017), we are having problems with correlative map where we use zip code to paint the zone in the map.

Yesterday, this map works correctly. In Power Bi desktop works

 

111.JPG

, but in power bi Embebbed not.

222.JPG

 

Has anyone had the same problem? How can we solve it?

 

Many thanks,

Javier.

Status: Delivered

I haven't been able to open my Power BI Desktop since I upgraded to the latest upgrade, Feb 2017. When I click "send frown" on the error message, it freezes there and I have to force it closed via Task Manager. I've tried submitting a support ticket several times on the site and it says "Error submitting request. Try again shortly." Google searches also fruitless. So now I'm here looking for help.

 

Here is my error message, copied in entirety:

 

Feedback Type:
Frown (Error)

Timestamp:
2017-02-14T15:55:23.5676092Z

Local Time:
2017-02-14T09:55:23.5676092-06:00

Product Version:
2.43.4647.541 (PBIDesktop) (x64)

Release:
February, 2017

IE Version:
11.0.9600.18282

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.6.1 or later [Release Number = 394271]

Workbook Package Info:
None

Peak Working Set:
158 MB

Private Memory:
137 MB

Peak Virtual Memory:
3.18 GB

Error Message:
The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. (Exception from HRESULT: 0x80070422)

Error Code:
-2147023838 (0x80070422)

Stack Trace:
System.Runtime.InteropServices.COMException (0x80070422): The service cannot be started, either because it is disabled or because it has no enabled devices associated with it. (Exception from HRESULT: 0x80070422)
   at System.Management.ThreadDispatch.Start()
   at System.Management.ManagementScope.Initialize()
   at System.Management.ManagementObjectSearcher.Initialize()
   at System.Management.ManagementObjectSearcher.Get()
   at Microsoft.PowerBI.Client.Telemetry.PowerBITelemetryManager.GetProcessorInfo()
   at Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

Invocation Stack Trace:
   at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
   at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
   at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.<>c__DisplayClass1.<HandleException>b__0()
   at Microsoft.Mashup.Client.ClientShared.UnexpectedExceptionHandler.HandleException(Exception e)
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
   at Microsoft.PowerBI.Client.Program.Main(String[] args)


User ID:
f7bf7c48-0b7c-475c-8646-88867d2ee7ae

Session ID:
52678f67-a9b4-40d7-8969-7e6ca0c70dab

Telemetry Enabled:
True

DPI Scale:
125%

Supported Services:
Power BI

Status: Needs Info

deleted filter comes back again and again

Status: Accepted
by blueant Frequent Visitor on ‎02-10-2017 07:18 AM

I added a simple filter(report level) in the report, saved the report. checked the dashboard.

 

Then I delete the filter, save the report, check the dashboard which seems good. 

 

But everytime when I refresh the dashboard, or go back to the report, the filter comes back! 

 

Thanks in advance!

Status: Accepted

Search Box on Slicer Missing

Status: Accepted
by MikeThibs Regular Visitor on ‎01-05-2017 04:39 PM

Hello,

     The Search Box on the Slicer Visualization seems to have a bug when a PBIX file is loaded to the Power BI Service. This issue is affecting the drop-down format of a Slicer. Also it seems to only affect Slicers with a larger amount of items. When there are 2 or 3 items in the slicer the search box will appear however if there are 20 plus or more items it is not working. I've tried several different browsers, so I don't believe that is the issue. Below are screenshot showing the search box has been enabled and the missing search box when you select the drop down. Please help!!! We're on the verge of rolling out hundreds of new Power BI accounts and this is a serious issue when you have large slicer needs.

 Search On.jpgSearch Not Showing.jpg

 

 

Status: Accepted

ArcGis dissapeared!

Status: Delivered
by yanthrax Visitor on ‎02-13-2017 11:55 PM

Hello!

 

Ive been sent here via the support ticket page.

Ive seen this issue once more on the forum, and the poor lad was pointed toward creating a support ticket. (Which raises the question, would you rather have a 30% chance to earn another membership if the guy isnt a premium member and wants help, or do you want to know a bug about your own software a lot of people encounter nowadays.. anyways, who am i to judgeSmiley Happy)

As is personally enjoy using the software and especially the ArcGIS map and dont need a detailed, personalized solution, i thought i'd provide some info to help fix the root of the problem (and..uhm..i need this report done..).

Please excuse the posting in what might be the wrong section, ive been sent here via the support page. Also excuse the label if you would not mind, English is my third language.

 

The problem:

Since around the 10th of february, when starting Power Bi (with ArcGIS enabled in options!) i get a error message which is pasted below. When unabling the ArcGis option, there are no error messages on startup. Either way, the ArcGIS button is gone! Smiley Sad

 

Does anyone have any (quick) fixes for this issue? Again, ive seen the issue in a dark corner of the forum but with no solutions yet.

 

Have a great daySmiley Happy

 

 

Error code:

Feedback Type:
Frown (Error)

Timestamp:
2017-02-14T07:47:11.7759056Z

Local Time:
2017-02-14T08:47:11.7759056+01:00

Product Version:
2.43.4647.541 (PBIDesktop) (x64)

Release:
February, 2017

IE Version:
11.0.9600.18537

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 nl-NL)

CLR Version:
4.6.1 or later [Release Number = 394271]

Workbook Package Info:
1* - nl-NL, fastCombine: Disabled, runBackgroundAnalysis: True.

Peak Working Set:
380 MB

Private Memory:
336 MB

Peak Virtual Memory:
3.84 GB

JS Error Message:
Cannot read property 'iconBase64' of undefined

Error Message:
An error occurred while rendering the report.

Stack Trace:
Microsoft.Mashup.Host.Document.JavaScriptException: An error occurred while rendering the report.
TypeError: Cannot read property 'iconBase64' of undefined
at Object.createVisualPlugin (ms-pbi://pbi.microsoft.com/minerva/scripts/VisualHostCore.js:1425:58)
at Object.<anonymous> (ms-pbi://pbi.microsoft.com/minerva/scripts/VisualHostCore.js:332:65)
at j (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.1.1.js:2:26860)
at Object.k.fireWith [as resolveWith] (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.1.1.js:2:27673)
at x (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.1.1.js:4:11120)
at XMLHttpRequest.<anonymous> (ms-pbi://pbi.microsoft.com/opensource/jquery/jquery-2.1.1.js:4:14767)

Invocation Stack Trace:
at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()
at Microsoft.Mashup.Client.ClientShared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace)
at Microsoft.Mashup.Client.ClientShared.FeedbackErrorInfo..ctor(String message, Nullable`1 errorCode, String requestId, Exception exception)
at Microsoft.Mashup.Client.ClientShared.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.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
at Microsoft.PowerBI.Client.Windows.FloatingDialog.StartDialog.Show(MainWindow mainWindow, WindowsHost windowsHost, IFileHistoryManager fileHistoryManager, IAuthenticationManager authenticationManager, IAuthenticationUIHandler authenticationUIHandler, ICloudConfigurationManager cloudManager, UpdateNotificationManager updateNotificationManager, IFileOperationUIHandler fileOperationUIHandler, IPowerBISettings powerBISettings)
at Microsoft.PowerBI.Client.Windows.MainWindow.ShowStartDialog()
at Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<>c__DisplayClass13.<Main>b__4(MainWindow mainWindow)
at Microsoft.PowerBI.Client.Windows.MainWindow.<OnMainWindowInitializationCompleted>b__41()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
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.ClientShared.WindowManager.ShowDialog[T](T form, IWin32Window owner)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)


User ID:
777bd124-44d0-494a-8653-38cba0c2f15e

Session ID:
6164cbe1-7616-4f2d-b9c3-1d492798fa5a

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\Yannick\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot2129867580.zip

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

Enabled Preview Features:
PBI_esriEnabled

Disabled Preview Features:
PBI_RedShift
PBI_Impala
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_allowBiDiCrossFilterInDirectQuery
PBI_clusteringEnabled

Disabled DirectQuery Options:
DirectQuery_Unrestricted

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

Formulas:


section Section1;

Active Section Contract:
{"id":0,"name":"ReportSection","displayName":"Page 1","ordinal":0,"visualContainers":[],"displayOption":1,"width":1280,"height":720,"config":"{}"}

Status: Delivered

Power point output function does not work properly.

Power point will be output in the default state even if narrowing down the conditions by filter or outputting power point.

Status: Accepted

In the new January, 2017 release, I get a "Report has already been published" error message when I try to use the PUBLISH option to Update a report that exists on the Service from Desktop.

 

- Steps:

--I updated a report in Desktop that had been previously published to the Service.

--I selected the PUBLISH menu option in Desktop

--I selected MY WORKSPACE (where the report was located)

--I received an error "Report has already been published" and the update failed.

 

I've tried with several different reports both with the Service running and with the Service not running.  I've also exited Desktop and restarted it and repeated the operation.  In all cases, I got the same error.

Status: Delivered

Bug in "Don't include in Report Refresh"

Status: Delivered
by ImkeF New Contributor on ‎01-10-2017 07:58 AM

There's a bug in "Don't include in report refresh" like described here: http://community.powerbi.com/t5/Desktop/Disabling-quot-Include-in-Report-Refresh-quot-works/m-p/1017...

unfortunately I didn't test correctly and this thread is closed, but the bug is still there and preventing solutions for problems like this:

http://community.powerbi.com/t5/Desktop/Big-file-needs-no-update/m-p/111341#U111341

 

If the query that shall not be refreshed is not referenced by any other query or part of a UNION-operation in DAX, then everything works fine, but if it is referenced as mentioned, then it will be loaded again.

A lot of the usecases for this features are of this kind, so this bugfix is really needed !!!

Status: Delivered

Can't publish a report from Power BI Desktop

Status: New
by jonward Occasional Visitor on ‎02-12-2017 12:03 PM

I am no longer able to publish reports from Power BI dekstop that I have been able to do previously.  I get this error: "An unexpected error occured while attempting to publish 'test.pbix': Unable to write data to the transport connection.  An existing connection was forcibly closed by the remote host". 

 

I tried creating a trivially small new workbook and was able to publish that OK but with a relatively simple 2Mb workbook I get this error.

 

I'm also unable to upload this directly from the Power BI service.  Again, I'm able to load the trivially small workbook but not this (or any other) workbooks, all of which have worked in the past.  In the Power BI Service I get the following error details:

 

Something went wrong.
 
Failed to publish Power BI Desktop file
Please try again later or contact support. If you contact support, please provide these details.
Activity ID54693ed1-211b-4068-8e82-46ba9a047997
Request ID9feccbba-5f29-ac3d-a18f-c38136f71375
Correlation ID0e52c4d0-1f3b-15ea-82ec-eef9bbd54865
Status code-1
TimeSun Feb 12 2017 19:47:32 GMT+0000 (GMT Standard Time)
Version13.0.1700.1165

 

Power BI Desktop Version: 2.42.4611.701 64-bit (January 2017) Installed today.

 

Login window blocked by "Working on it" spinner popup after Power BI Desktop idle in background for a bit. I didn't nail down the time but both times it was over 20 minutes. The login expires after an indeterminate amount of time of inactivity, over 20 minutes at least. Clicking publish brings up the login window but is behind the "Working on it..." popup.

I have to end the task, open Power BI, click login up in the top right corner, then I can publish.

 

screen shot of issue

 

 

 

Status: Delivered

Power Query should not wrap simple xml elements in a table

Status: Delivered
by fransbus Occasional Visitor ‎02-10-2017 04:16 AM - edited ‎02-10-2017 04:57 AM

Import this xml into PBI Desktop:

 

<?xml version="1.0" encoding="utf-8"?>
<table>
	<row>
		<AllValues>111</AllValues>
		<AllEmpty></AllEmpty>
		<Mixed1>abcd</Mixed1>
		<Mixed2>abcd</Mixed2>
		<Mixed3></Mixed3>
	</row>
	<row>
		<AllValues>222</AllValues>
		<AllEmpty></AllEmpty>
		<Mixed1></Mixed1>
	</row>
	<row>
		<AllValues>333</AllValues>
		<AllEmpty></AllEmpty>
		<Mixed1></Mixed1>
	</row>
</table>

 

In Query editor the result is:

 

Knipsel.PNG

 

In the UI you cannot expand the columns AllEmpty and Mixed3, since PQ cannot find any columns in the empty tables.

Note the difference between Mixed1 and Mixed2, in row 1 they both have the same value 'abcd'. However, in Mixed1 this value is wrapped in a table.

 

Solution: Power Query should never wrap simple xml-elements in a table. An empty xml-element should always transform to a null, and so should a missing element.

 

Workaround: use a function like Chris Webb describes here (which fails for AllEmpty above, btw).

 

Solving this issue would make processing xml files in PBI and Excel a lot easier!!

 

Thx.

Status: Delivered

Not sure if this is related to the data refresh issue, but starting yesterday I have two different external customers (both in California) that view different dashboards.  They are able to get to the dashboard frames, however get an error stating that "something went wrong.. unable to load the data model".

 

Anyone else experienceing this with external users?

 

Our data is on prem, we use the personal gateway, and the external customers are using the link provided in the original MSFT email I shared with them.

 

Thanks,

 

Status: Needs Info

KPI indicator text size adjustment

Status: Accepted
by v-kaslen Occasional Visitor on ‎01-27-2017 03:59 PM

On the video posted at https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-kpi/, it clearly shows (at minute 5:06) an adjustment for the text size under the indicator formatting options for the KPI visual.  The date at the top of the page is Sunday, January 22, 2017.

 

But, in the latest version of Power BI desktop (Version: 2.42.4611.901 64-bit (January 2017)), there is no such option for adjusting the text size.  I need to be able to decrease the text size in the visual for a report I am creating.

Status: Accepted

errorJPG.JPG

I'm getting this error since yesterday on a new dataset. It is a simple excel file table. I've done the following.

Signed out of Power BI Desktop and back in

Got the latest personal gateway

turned the gateway service off / on

republished multiple times during this process.

 

Others seem to be having the same issue. see thread here

There is a current support site error message, but it is specific to SharePoint as a data source only.

Status: Accepted

Odd behavior in Cloud vs Desktop... PBID displays the time with zone (-7) as expected, cloud service does not.

Left side is cloud service, right side is PBID.

Very simple 'Refreshed' Query...entered a value into the 'Enter Data', added a custom column, deleted sample data:
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Last Refreshed", each DateTime.AddZone(DateTime.LocalNow(),-7)),
#"Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Column1"})
in
#"Removed Columns"

Expected behavior or bug?

Capture.JPG

 

Status: Delivered