When a Line Chart's y-Axis property 'Start' is set to 0 and 'End' set to 'Auto' and all values to be dispayed are 0 or BLANK(), the y-Axis starts at -1 instead of 0. ... View more

I work with Salesforce objects connection. Yesterday, each query step took several seconds to run (1-3 seconds) Today, I can wait for a step 20 MINUTES..... The Salesforce itself evreything works fine. Is there a problem with Dataflow? ... View more

I started experimenting with Goals last week, and of course setup a scorecard and named it "Test".  It is displayed as "Test" in https://app.powerbi.com/goals/hub.  However, I was able to rename it in the /scorecards/ subsection, but the original name "Test" still shows up in the hub, and to my disappointment, our production App.  I've hidden the scorecard from the production App, but cannot seem to delete it in the hub.  The delete button gives me a warning, then does nothing. ... View more

Hi there, At present, it doesn't support adding a Hierarchy field like Date Hierarchy into the report. When opening the Value adding dialog, select the Hierarchy field, no response.   ... View more

After the Windows update applied last week a colleague and I can no longer open Power BI successively; WE can open the program once but if we close it, it will not launch a second time - we both get the error trace shown below. Earlier versions do not behave differently.   Recently installed Windows updates include KBs 5001028, 4601056, 5001406       Feedback Type: Frown (Error)   Error Message: We’re sorry. A problem occurred while rendering the report, and Power BI Desktop will close now. Please restart.   Stack Trace: Microsoft.PowerBI.Client.Windows.CefSharpFramework.Exceptions.CefProcessCrashedException at Microsoft.PowerBI.Client.Windows.CefSharpFramework.CefWebBrowser.<>c__DisplayClass56_1.<OnRenderProcessTerminated>b__1()   Stack Trace Message: We’re sorry. A problem occurred while rendering the report, and Power BI Desktop will close now. Please restart.   Invocation Stack Trace: at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage) at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e) 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__DisplayClass15_0.<HandleException>b__0() at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.PowerBI.Client.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e) at Microsoft.PowerBI.Client.Windows.MainWindow.Microsoft.PowerBI.Client.Windows.CefSharpFramework.ICefBrowserHost.OnFatalError(FeedbackActionInfo feedbackActionInfo, Exception e, String knownErrorDetailsUrl) at Microsoft.PowerBI.Client.Windows.CefSharpFramework.CefWebBrowser.<>c__DisplayClass56_1.<OnRenderProcessTerminated>b__1() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_1.<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.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass4_0.<Main>b__1() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Program.Main(String[] args)     PowerBINonFatalError_ErrorDescription: ProcessCrashed   PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.92.1067.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.CefSharpFramework.CefWebBrowser+<>c__DisplayClass56_1","Error":"Microsoft.PowerBI.Client.Windows.CefSharpFramework.Exceptions.CefProcessCrashedException - ProcessCrashed","MethodDef":"<OnRenderProcessTerminated>b__1","ErrorOffset":"21"}   Snapshot Trace Logs: <user>\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot585095be-3c0f-4a29-98b6-c216af015cc1.zip   Model Default Mode: Empty   Model Version: PowerBI_V1   Performance Trace Logs: <user>\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip   Enabled Preview Features: PBI_JsonTableInference PBI_NewWebTableInference PBI_ImportTextByExample PBI_ExcelTableInference PBI_eimInformationProtectionForDesktop PBI_compositeModelsOverAS PBI_newFieldList PBI_cartesianMultiplesAuthoring   Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_azureMapVisual PBI_dataPointLassoSelect PBI_narrativeTextBox PBI_dynamicParameters PBI_anomalyDetection   Disabled DirectQuery Options: TreatHanaAsRelationalSource   Cloud: GlobalCloud   Browser name: ModelView   PowerBIUserFeedbackServices_IsReported: True   Formulas:     section Section1; ... View more

We have a report that is used by hundreds of users in presenting data to customers, and we're finding that the data colors in the same exact visual with the same exact legend headings changes from one day to the next when the report is accessed on the service. Note the item BILL is a different color yesterday, vs. today's output. Obviously, we'd like the colors to remain consistent for customer presentation as well as user understanding from day to day. Both images below are from the service.    ... View more

There's a frustrating bug with Composit Models. Append Queries are somehow always flagged as direct queries, so you can't do transforms on any append query. You also can't load any append queries when you have the Composit Models preview feature activated.   Here's a short walk-through to produce the errors and issue: Activate the Composite Models preview feature in Power BI Desktop and Restart PBI Desktop to take effect. Get Data from Excel and Edit 2 spreadsheets that you want to append. In Power Query, turn off / disable the "Enable Load" on both imported spreadsheets. Create an Append Query as New and append both spreadsheets to a new query. Make any transforms you want or none at all. Apply and load the append query An error occurs on the load "This query contains transformations that can't be used for DirectQuery." Even if you remove all other steps except for the 1st step to append, you get the error. Another realted issue occurs if you turn on the "Manage Aggregations" preview feature. With that option activated, you see the same error in the query as a yellow top warning banner in the append query. It gives you a button option to click to "Switch all tables to import mode" But this does not work at all. If you click it and then select another query and then reselect your append query it's back. Also loads still don't work.   To resolve the issue. you have to do the following: Deactivate both preview features for Manage Aggregations and for Composit Models. Restart Power BI to take effect. Open your PBI file and open Power Query Delete your append query Recreate your append query Everything works as expected. To summarize, the only way to fix the append query is to deactivate preview feature and remake the append query with the feature off.   Analysis: Somewhere in the PBI file the modes for the queries are getting switched, and stored to directquery, but are not able to be changed.  This appears to be a bug, as the whole point of doing a composite model is to be able to mix and match directqury and import queries in a single model. However this bug prevens you from using append queries. ... View more

I see Create, Access, Settings. But no Publish App, Update App button.  I'm going in via apps and via workspaces and no way to update or publish apps.  ... View more

When using Power Query to run an Python or R script that writes data to a CSV, the resulting CSV automatically converts text to numbers and drops leading zeroes, even though the data type is specified as text both in Power Query and in the Python/R script. The issue is not present when running exactly the same script directly in R or Python, so it seems to be an issue related to Power Query.   Here are some examples scripts that can be used to reproduce the issue. Note that the data type is specified as text both in Power Query and inside the Python/R script. Using R script:     let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjA3MDUzU4rViVYyNDQwMDICMw2MDQwMgcxYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), #"Run R script" = R.Execute("# 'dataset' holds the input data for this script#(lf)#(lf)dataset$Column1 <- as.character(dataset$Column1)#(lf)fileName <- paste(""C:/test.txt"")#(lf)write.table(dataset, sep = "","", file = fileName, quote = FALSE, row.names = FALSE, col.names = FALSE)",[dataset=#"Changed Type"]) in #"Run R script"     Using Python script:     let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjA3MDUzU4rViVYyNDQwMDICMw2MDQwMgcxYAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), #"Run Python script" = Python.Execute("# 'dataset' holds the input data for this script#(lf)import pandas#(lf)data = pandas.DataFrame(dataset)#(lf)data = data.astype(str)#(lf)data.to_csv('C:/test.txt')",[dataset=#"Changed Type"]) in #"Run Python script"     Input data is (as text): 070566 110022 030012    Expected output is: 070566 110022 030012   Actual output is: 70566 110022 30012   See more in these topics: https://community.powerbi.com/t5/Power-Query/Keep-leading-zeroes-when-export-to-CSV-using-R-or-Python-script/m-p/1824505#M54409 https://community.powerbi.com/t5/Power-Query/Python-script-step-drop-leading-zeros/m-p/1587259   ... View more

When you have multiple datasources to the same IP address and different users (For security reasons), if you try to change a datasource using an account with permissions to see all the available datasources on your gateway, the dataflow will overwrite and take the very first one datasource available on the dropdown list.   To solve this issue:   Login with an account with exclusively permissions over your desired datasource on your gateway Takeover the dataflow with the issue Change the datasource on your dataflow Refresh your dataflow   Regards   John Bocachica ... View more

Hi,   I am reporting a bug here on Power BI Service - - Line and Stacked Column Chart    The line value behave differently after publish the pbix file to app.powerbi.com   Snapshot 1  - This is the pbix file snapshot, i set the Y-axis start value = 0     Snapshot 2 - This is the snapshot in app.powerbi.com after i publish the pbix file you can see that the start value of y-axis is still 0 , but the line value is showing almost the same height of the column bar which is incorrect.     Snapshot 3 - then I changed the start value of y-axis to -1, it works well.     But this is not correct behvior, even though I set the start value of y-axis as 0, it should behave the same as pbix file.   Please resolve this ASAP, I need to set my y-axis start value as 0 as per my needs. ... View more

Hi everyone,   I have an issue with Power BI Subscribe. I made a Dashboard and using feature Pin Live Page to add a report into Dashboard. After, I setup a schedule Subscribe for this Dashboard.   Often, it's good. But from Sunday 16th-Sep, it's send to me a File wrong. It just snapshot a half of Report.   Please help me know what happend?   ... View more

Since at least the April 2021 update, I've been running into this error - whenever I click 'Close & Apply' from the Power Query Editor, a mysterious blank window pops up:   This blank window prevents the Close and Apply action from taking place.  I usually repeatedly click the 'X' to close the window and then quickly click 'Apply Changes', but this usually takes 5-10 times before working.  Please fix quickly!   ... View more

Some times, when you are using a Dataflow as a datasource, at the moment you want to close and apply to create your visuals you may receive the error OLE DB or ODBC error: type mismatch (exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH))   To solve that issue [workaround]:   Go to your query editor Duplicate the affected table Disable the load of the affected table Click on apply (Just apply, not close and apply) to verify the workaround If it's working, delete the affected table Rename the new table with the previous name Close and apply Regards ... View more

Hi there,   For some reason, the conditional formatting on Matrix of my reports are not working on Service. They are working fine on Desktops. Anyone else having this issue Thanks ... View more

To see the error, just use the Power BI embedded demo site and try to set slicer filters.  Javascript error below. It didn't work most of last week, but then was working Friday.  Now doesn't work again.  I had posted in Developer forum, just re-posting in Issues area.   ... View more

Installed upgrade to desktop version and now receive the following: Feedback Type: Frown (Error) Error Message: AS Precess PID=1904 has exited with ExitCode=-1073741511, ExitTime=2021-05-30T21:08:38:3059901-03:00. ... View more