New Idea

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

Hi, Thanks for implementing some new Matrix features. Nevertheless I noticed a bug when drilling down into the columns: - drilldown works as expected BUT there is no way to drill up again.

Matrix drill down.JPG

Thanks for having a look into that

Best regards

Andreas

 

Status: Delivered

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 Super 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

Date Slicer behavior incorrect in Service

Status: Delivered
by mcolb88 Frequent Visitor on ‎02-20-2017 11:52 AM

Have a date slicer in Power BI desktop, works as expected. Publish to service and two differences noted in behavior:

 

1) When hovering over the header, I no longer have control over the type of slicer to show, BETWEEN, BEFORE, AFTER, etc.

 

2) Tried to pick a single date while in between mode; 2/16/2017. Works as expected in PBI desktop, in service, I pcik 2/16/17 for start date, then pick 2/16/17 for end date and control automatically switches to 2/20/17????

 

Anyone else experience this?

Status: Delivered

 

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

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: Delivered

KPI indicator text size adjustment

Status: Delivered
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: Delivered

Publish Report Error if Not Signed In

Status: Delivered
by dkkip05 Frequent Visitor on ‎01-13-2017 07:32 AM

Power BI Desktop seems to be signing me out of my Power BI account. When I go to publish a report while not signed in it asks me for my credentials, but doesn't allow me to type anything in. I have to open Task Manager and Force Close Power BI, reopen, Sign In, then publish.

Status: Delivered

Hello

 

Still unable to refresh on Power BI Service (Online), where we have a numbe of reports that employees rely on for daily data. 

 

Do we have an idea when this is going to be fixed? I am a user in the UK

 

Cheers


Rob

Status: Delivered

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

If you try to upload Power BI content and haven't checked to see if you are still signed in when you try to publish the file PBI hangs. You can't enter credentials as PBI is attempting to upload the file.

Status: Delivered

Problems with correlative map(Zip code)

Status: Delivered
by Rayito169 Frequent Visitor on ‎02-14-2017 08:42 AM

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

Important Issue:
 Tested on different machines using Windows 10 and the latest version of PowerBI - February 2017 (2.43.4647.541 64-bit)

 

  • Adding a image to page background ether on fill or fit, will cut the image, no matter what resolution is tried.

 

We’ve been using this feature, of adding a image to a page background, since last year without any problem.
On the the latest release of the PowerBI, each time we add a new image to page background it will be cutted and doesn’t fill the page.

(Images with the same resolution that worked before. Reports made with previous PowerBI version display the image perfectly without cutting edges.)

 


 Examples:

 

1) How it worked while using Jannuary 2017 or previous PowerBI releases.
PB_Jannuary.jpeg


2) What is occuring using the same image on PowerBI latest release, February 2017 with fit option

 PB_FEV-FIT.PNG

2) What is occuring using the same image on PowerBI latest release, February 2017 with fill option
PB_FEV-FILL.PNG

Status: Delivered

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

Previously there was a message on the Microsoft Support Page that it is a known issue, but now it shows "No known issues..."

But I still cannot update my dataset Smiley Sad

I have 8 OData API connections and 6 Web connections to OneDrive for Business Excel Files

First - it shows error "Can't refresh your data: The credentials you provided for the Data Source are invalid".

When I go to settings and enter the credentials in 3 places with "X" error mark next to them - it accepts them (I don't know why it shows this error in the first place).

Then - I press on Refresh now - and after showing "Prepare for refresh" for several seconds - nothing happens. I don't even see the "working circle" next to my dataset.

I just have to update in Destop and republish

Please help...

Please

Thank you

Michael

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

When using dashboard tiles, one can set a custom link to have the tile navigate to any URL. Currently in the Service, if the Custom URL is set, and the "Open Custom Link in Same Tab" is checked to "Yes", then the following behavior is experianced.

 

Test case: Custom URL used to navigate to a different report page rather than the one the tile was pinned from. "Open Custom link In Same tab is checked to "Yes". The tile is clicked and the user does not go anywhere.

I tested further, and if I add a report URL from a different Power BI report, the behavior of the tile is such that on click, it takes me to the other report dashboard where visuals were pinned from the report.

 

It would appear, that the Custom URL link is not allowing me to access the report URL when I have set it to open in the same tab, but rather rolls me up to the Dashboard.

 

If the "Open Custom Link in Same Tab" is checked to "No" - the tile works as expected.

Status: Delivered

KPI visual doesn't display time values

Status: Delivered
by atapia New Member on ‎01-30-2017 03:24 PM

Hi

 

I'm working on a dashboard for my team on a Call Center, I'm looking to show their AHT against the goal in a KPI visual, However, it displays correctly in the Desktop app but when I publish it, it will show a legend (Blank) for both, the current and the goal values.

 

This also happens with string values. With any other data type it shows correctly.

 

Any thoughts?

Thanks

Alberto

Status: Delivered