New Idea

Invalid credentials on Sharepoint folder

Status: Accepted
by csabil Frequent Visitor on ‎11-22-2016 10:46 PM

Since yesterday I'm having an issue connecting to an excel file in a Sharepoint folder. It was already working, but I made some changes and republished it. Refresh works fine in Power BI Desktop, but online. It seem it's trying to connect to a Sharepoint list, instead of folder. I have an other report connecting to an other excel file in the same folder and it works fine. Could this be connected to the issue in North Europe? I'm in that datacenter.

 

Capture.PNG

Status: Accepted

Mixpanel query failure

Status: Needs Info
by kenzhang123 Visitor on ‎03-01-2017 02:39 PM

I'm a new user to PowerBI. I couldn't get around with mixpanel connector. It fails on me. the first screen shot works. The second doesn't work. I suspect there's a bug.

Capturework.PNG

 

The screen shot below has the perfect structure (in my opinion) I verify it in chrome from mixpanel. But it won't retrieve and give me an error code 400

Capturebug.PNG

Any help is appreciated. I'm very frustrated.........

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

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

I noticed today that ALL of my attribute slicers are now set to 'highlight' other visuals rather than 'filter' them. I didn't make this change. They have been set to filter for 2 months. Perhaps this was triggered by the January update? Lots of rework involved to set them up to filter again.

Status: Needs Info

Background images in Power BI Desktop work fine. Either after publishing the report to Power BI Service or creating a new report there, the background picture centers in the canvas and there is no way of fixing it. Even removing the image and trying to apply a color background behaves in the same way. The only way I´ve found as a workaround is placing visuals in each corner of the report priort to publishing but this is crearly undesirable in the long run.

 

PowerBI DesktopPowerBI DesktopPowerBI ServicePowerBI Service

You can see all the white space left where you can place visuals.

 

Regards,

Juan Pablo 

Status: Accepted

I create a report on Power BI Desktop with a Project Online Odata feed as data source.

I can connect and update from PBI Desktop without any problems.

 

However, when i publish it to Power BI, and go to Schedule Refresh, i get this error under Data Source Credentials:

1.png

When i try to edit the credentials, i set to OAuth2 and enter the correct credentials but i got the error below:

 

1.png

 I'm pretty sute that the correct authentication method to Odata feed is OAuth2, but i tried the other methods and got the same error

 

 I'm not able to update the credentials in any situation. I've tryied to republish the reports, create a new one from scratch but i got always the same situation.

 

Best Regards,

Alessandro

Status: Accepted

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

Unable to cast object of type 'ComDataConvert' to type 'ComDataConvert'. The exception was raised by the IDataReader interface. The sync works perfectly on power bi desktop. Any help in this would be greatly appreciated.

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

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

We have a production implementation of Power BI for which we turned on device based Conditional Access (CA), and added relevant AD groups. After turning on CA, users in the device based AD group are unable to sign in from Power BI desktop and also cannot sign in upon installation of a new Enterprise Gateway.

We get the following message: Unable to sign in. Sorry we encountered an error while trying to sign you in. Details: AADSTS50000. Device platform Unknown used by the user is an unsupported device platform. Supported device platforms are iOS, Android, and Windows flavors.

We are on a Windows platform and tested from Windows 8 and Windows 7 machines, and encountered the same error on both. This issue applies to October 2016 and September 2016 versions of desktop. To prove that CA triggered this issue, we used a test user not in the device based AD group. The test user was able to sign in successfully.

This issue is critical as it prevents us from being able to publish directly from Power BI desktop and prevents users from installing a new Enterprise Gateway.

Please let me know if you need any additional information. If you need Trace ID, Correlation ID or Timestamp, I can provide it via email.

Status: Investigating

Can't publish a report from Power BI Desktop

Status: Accepted
by jonward 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
Status: Accepted

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

Search on a slicer set as dropdown

Status: Accepted
by gooranga1 Member on ‎01-18-2017 04:53 AM

In the January 2017 release it looks like the Search facility on a slicer that is set to a drop down has been removed? 

 

I can set up a slicer as list and search it but as soon as I switch it to a drop down I can no longer search.

 

Can this be re-instated?

Status: Accepted