Hi,   I want to AlignSlicer label or Slicer header in the centre. By default the alignment in the Left side.  Please suggest a solution. ... View more

Hello,   I'm encountering an unexpected behaviour while connecting with Direct Quert to Power BI dataset and creating local (composite) model from it.   'Show values of the selected field' option of Field Parameters when they are used within a slicer (blog announcment) is not available anymore.   If I'm connecting directly via DQ to PBI dataset this option works fine, it stops working when clicking 'Make changes to this model' on lower bar next to Storage Mode information. As soon as I make this change, slicer with this option breaks and the error is generic "Something's wrong with one or more fields". If I try to set this up while already being in Composite model mode this option is not available in context menu.   I realise that Field Parameters are preview feature, but is this expected behaviour? It is not described as limitation in documentation. ... View more

Hello,   On the Support Services Customer Paginated Report, unable to export the PDF of the report, regardless of the period selected/customer.   Attempted with a different file format, on a different browser, launched the VPN etc and receiving the error message :     Thank you in advance for your help.   ... View more

# Demo - Create Power BI Reports Quickly in Jupyter Notebooks i got this error,    ... View more

I'm having a dataflow created in my workspace and i'm trying to move it to another workspace using import model (Export.json file), with data having native query, While doing this i'm getting something like this    ERROR: invalid dataflow parameter value. Exception details: The allownativequeries attribute of the mashup is set to true for the dataflow definition. for security reasons, allownativequeries should be set to false on import( can be set to true after import from the powerBI service) please seeet allownativequeries to false and try again   I treid to change allownativequeries attribute in my exported json file to false and then imported it to my another workspace, now what happens is my data is empty, because the native query attribute is set to false   This is my sample json where i enabled allownativequeries to false { "name": "Native _query", "description": "", "version": "1.0", "culture": "en-GB", "modifiedTime": "2023-05-02T08:56:12.9249656+00:00", "ppdf:outputFileFormat": "csv", "pbi:mashup": { "fastCombine": false, "allowNativeQueries": false, "skipAutomaticHeaderAndTypeDetection": false, "queriesMetadata": { "Query": { "queryId": "c090e6d9-82f2-4b54-9b6e-6b5a0f640e1a", "queryName": "Query", "loadEnabled": true }, "Query (2)": { "queryId": "ac96f7cb-b93c-4ca4-8b7b-1881cbaf39be", "queryName": "Query (2)", "loadEnabled": true } },   How can i enable NativeDatabaseQuery option to TRUE in powerBI without actually changing in the json file? (Because the condition must be set to True in order to get the native query data ) ... View more

Boa noite. Ao acessar o Power BI Desktop e acessar a Aba VIsualizações expandida não exibe os icones dos gráficos, conforme print abaixo. E quando recolhemos aparece os ícones dos gráficos e aparentemente isso é um possível erro no código estrutural do Software.   Poderiam por gentileza verificar. Atenciosamente. ... View more

Feedback Type: Frown (Error) Timestamp: 2023-05-03T22:14:42.6157052Z Local Time: 2023-05-03T15:14:42.6157052-07:00 Session ID: af352445-90ba-41cf-8042-825756f3ec7c Release: April 2023 Product Version: 2.116.966.0 (23.04) (x64) Stack Trace: Microsoft.PowerBI.Modeler.ModelingASOperationException at Microsoft.PowerBI.Modeler.ModelManager.<>c__DisplayClass253_0.<SaveChanges>b__0() at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass6_0`1.<RunInActivity>b__0() at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity(ModelingActivityKind activity, Action action) at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity[T](ModelingActivityKind activity, Func`1 action) at Microsoft.PowerBI.Modeler.ModelManager.SaveChangesForCommit(String description, Boolean recalc) at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.Commit(Boolean recalc) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ModelAuthoringTransaction.Commit(RecalcBehavior recalcBehavior) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.ExtendedModelChangeScope.ExecuteChange(ModelChange modelChange, Boolean isTrustedSource, Boolean saveChange, RecalcBehavior recalcBehavior, String descriptionToTrace) at Microsoft.PowerBI.Modeling.Engine.ModelingEngine.<>c__DisplayClass16_1.<RouteModelChangeAsync>b__3(IExtendedModelChangeScope scope) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass10_0.<RunExtendedModelChangeAsync>b__0(IExtendedModelChangeScope scope) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<>c__DisplayClass11_0.<<RunExtendedModelChangeAsync>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Modeling.Engine.Authoring.AsyncModelAuthoringService.<ContinueWithAsyncOperation>d__14.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Modeling.Engine.ModelingEngine.<RouteModelChangeAsync>d__16.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Report.<>c__DisplayClass70_0.<<SynchronizeLooselyWithQueriesAsync>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Report.<SynchronizeLooselyWithQueriesAsync>d__69`1.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringRoutingService.<>c__DisplayClass18_0.<<RouteToLocalModel>b__0>d.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.Modeling.ModelAuthoringRoutingService.<RouteToLocalModel>d__18.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.ModelAuthoringHostService.<ApplyCore>d__7.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.Client.Windows.ModelAuthoringHostService.<ExecuteAndShowFrownOnException>d__15`1.MoveNext() PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.116.966.0","ModuleName":"Microsoft.PowerBI.Modeler.dll","Component":"Microsoft.PowerBI.Modeler.ModelManager+<>c__DisplayClass253_0","Error":"Microsoft.PowerBI.Modeler.ModelingASOperationException","MethodDef":"<SaveChanges>b__0 - PFE_OLEDB","ErrorOffset":"108"} InnerException0.Stack Trace: at Microsoft.AnalysisServices.Tabular.Model.SaveChangesImpl(SaveOptions options) at Microsoft.PowerBI.Modeler.ModelManager.<>c__DisplayClass253_0.<SaveChanges>b__0() OS Version: Microsoft Windows NT 10.0.19045.0 (x64 en-US) CLR Version: 4.8 or later [Release Number = 528372] Peak Virtual Memory: 70.3 GB Private Memory: 702 MB Peak Working Set: 947 MB IE Version: 11.789.19041.0 User ID: d0b2c20c-5e8e-41fc-bd73-baee9ce2f405 Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False. Telemetry Enabled: True Model Default Mode: Composite Model Version: PowerBI_V3 Enabled Preview Features: PBI_enableWebView2 PQ_WebView2Connector PBI_sparklines PBI_scorecardVisual PBI_NlToDax PBI_fieldParametersSuperSwitch PBI_horizontalFusion PBI_optimizeTabRibbon PBI_relationshipEditPane PBI_setLabelOnExportPdf Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_azureMapVisual PBI_b2bExternalDatasetSharing PBI_enhancedTooltips PBI_angularRls PBI_onObject PBI_dynamicFormatString Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 150% Supported Services: Power BI ... View more

Power Query fails when an Excel Range is used as a data source and the range spans multiple Workbooks. I understand ranges should not span Workbooks so this is low priority.    Here is an example of the Range definition  ='April 2023'!$A$1:'March 2023'!$DE$80   Here is the trace below. This is 100% repeatable.    Unexpected error: Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) Details: Microsoft.Mashup.Client.Excel.Shim.NativeExcelException: Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) ---> System.Runtime.InteropServices.COMException: Catastrophic failure (Exception from HRESULT: 0x8000FFFF (E_UNEXPECTED)) --- End of inner exception stack trace --- Server stack trace: at Microsoft.Mashup.Client.Excel.Interop.NativeExcelInteropUtils.ValidateResult(Int32 result, Int32[] expectedValues) at Microsoft.Mashup.Client.Excel.NativeExcelFunctionsC2RBase.Microsoft.Mashup.Client.Excel.INativeExcelFunctions.TryGetNamedObjectProperties(IntPtr workbookPointer, String name, NamedObjectProperties& namedObjectProperties) at Microsoft.Mashup.Client.Excel.ExcelHost.<>c__DisplayClass8_0.<TryGetTable>b__0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3_0`1.<SendAndMarshalExceptions>b__0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass2_1.<SendAndMarshalExceptions>b__0(Object null) Exception rethrown at [0]: at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.Mashup.Host.Document.ExceptionExtensions.CaptureAndRethrow(Exception e) at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback) at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions[T](SynchronizationContext context, Func`1 callback) at Microsoft.Mashup.Client.Excel.ExcelHost.TryGetTable(PackageReference packageReference, String tableName, Int32 skip, Int32 take, Byte[]& content, Boolean& columnNamesGenerated, String& errorMessage) at Microsoft.Mashup.Host.Document.Evaluation.ExcelService.TryGetTable(String name, Int32 skip, Int32 count, IDataReader& dataReader, Boolean& columnNamesGenerated, String& errorMessage) at Microsoft.Mashup.Host.Document.Evaluation.Services.RemoteExcelServiceFactory.Stub.OnTableRequest(IMessageChannel channel, TableRequestMessage request) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.ChannelMessenger.ChannelMessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel) at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing) at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_TableSource() at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_TableSource() at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled) ... View more

What does this error message mean, and how do i fix?   "Couldn't publish to Power BI" x An error occured while attempting to publish 'New Reports - Usagepbix': Too many automatic redirections were attempted. ... View more

Field Parameter is working in PowerBI Desktop but not in PowerBI Server. Is there a solution or workaround? Thank you! ... View more

Bug: Filter Pane Visibility on App Differs to Individual Report   I've republished a report to the service and updated the app to suit, however the filter pain is completely unavailable on the app but is visible on the report. I've ensured it's visibility in edit mode, as well as disabling it, publishing and enabling it again for a subsequent publish - but it wont enable on the app at all (specifically the report within the app).   I've tried multiple browsers and cleared the cache, no joy. It has been enabled in the past, so I've no idea if it's an issue with the latest release - but I'm surprised others haven't mentioned it, so it's doubtful to be widespread.   I originally had filters on a separate bookmark, but I've removed them all now in favour of the filter pane for everyone to use across all pages, but since I can't get them working on the main app that everyone uses they currently have no filters at all (unless they access the report separately, but not everyone has access to that). ... View more

I have some parquet files stored in ADLS Gen 2. When I connect using Azure data lake gen 2 data source I get an error    Could not load file or assembly 'ParquetSharp, Version=0.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified     I previously got this error when refreshing data source in the March 23 version .   Powerbi version March 2023 Issue  Parquet Connector broken after February 2023 update    ... View more

Hello, I'm working on a custom data connector for Power BI and I'm facing an issue while retrieving input field value from an optional field in the dataSourcePath when using OAuth 2.0   Here's an example code snippet for the authentication process:   StartLogin = (dataSourcePath, state, display) => let url = Json.Document(dataSourcePath)[url], clientId = if(Json.Document(dataSourcePath)[client_id]=null) then "default_dc" else Json.Document(dataSourcePath)[client_id], codeVerifier = Text.NewGuid() & Text.NewGuid(), codeChallenge = "", AuthorizeUrl = url & Uri.BuildQueryString([ client_id = clientId, response_type = "code", code_challenge_method = "S256", code_challenge = codeChallenge, state = state, scope = "profile openid", redirect_uri = redirect_uri]) in [ LoginUri = AuthorizeUrl, CallbackUri = redirect_uri, WindowHeight = 600, WindowWidth = 450, Context = [ codeVerifier = codeVerifier, uri = url, client_id = clientId ] ];   If the field 'client_id' is mandatory, then the value is correctly fetched. However, when I set the field to be optional, the value 'Json.Document(dataSourcePath)[client_id]' is null, regardless of the value of the field.   It seems like a bug in the Power BI connector when using PKCE authentication (OAuth 2.0).   For your information, this behavior only occurs when using PKCE authentication. Other authentication modes, such as UserPassword, work fine.   Let me know if you need any more informations.   Thanks. ... View more

I have the 'Web page connector infrastructure update' preview enabled. In a report, I'm using the web connector to download data from a lot of different web pages. (The only data source I'm downloading from in this report are web pages.)   In Power Query Editor, there were no issues getting a preview and seeing the data from the tables from the different web pages. However, when I tried to apply the changes, I always get a 'We timed out waiting for the web page to load' errors trying to load data from the different web pages.   Given there were no issues in Power Query Editor, I should not be getting these timed out errors when trying to apply the changes. There should not be a limit to the number of web pages you can use with the web connector. (In the same report, I previously was able to get data from 3 different web pages with no issues.) If there is a limit on the number of web pages you can use the web connector with, this needs to be documented. ... View more

Scorecards that have been set up in Power BI metrics, which were previously updating correctly, are randomly not pulling through the correct values from dashboards. I say randomly because sometimes these values pull through correctly, other times, history hasn't updated in a couple of weeks, and clicking through to the underlying report shows a different number to that number displayed on the dashboard.   Examples below:   Value currently showing in the scorecard as '102.74%':     History shows that the goal hasn't had a new value pulled through since the 20th of April:     But the underlying connect is showing that the data was last updated yesterday:   And clicking through to the undelying report shows that the correct value should be '95.9%':     But for other scorecards, the values are pulling through correctly, and the figures are accurate when compared to the underlying report:     Is the PBI team able to investigate whether this is a known issue or not with scorecards at the moment?   Thanks Mitch   ... View more

Deploying a dataflow between deployment pipeline environments breaks the underlying connections, specifically for a data source using the on-premises data gateway and the Oracle data connector. The data flow has to be updated using the same steps to create the data flow in order for the data to be refreshed correctly. There does not seem to be a way to choose a specific connection for a dataflow between environments. There are many instances where someone would need multiple different connections to the same datasource using different credentials. ... View more

I have a Power BI Paginated report with several dozen subscriptions. However when I try to add a new subscription with default parameters, I get an error message in my email instead of the report subscription.        When I inspect the parameters, I can see the defaults are missing despite the report rendindering fine.     Other similar reports with parameters that have multiple values from a dataset work fine with subscriptions. How can I get this report fixed without rebuilding it? ... View more

Error of credentials when creating data source as files although they are correct, it is only in this type of source since when they are databases there are no problems, then the detail: Unable to create the data source. Details:   No se puede crear el origen de datos. Credenciales de conexión no válidas. TERRA BI MX: The credentials provided for the File source are invalid. (Source at d:\bi terra\bi qa\formatos de carga\ventas.xlsx.) Id. de actividad: c5c6d69f-c3cb-4cb0-bbf0-88f4f6b7ffab RequestId: d257c041-80bf-4eb5-abed-cea914d39259 URI de clúster: https://api.powerbi.com Código de estado: 400 Hora: Tue May 02 2023 11:34:41 GMT-0600 (hora estándar central) ... View more

Datamart is "refreshing" but it is producing empty tables with no fields instead of populating the actual data from the dataflows. This issue has been occuring for the 2 weeks.  When I "edit" the Datamart the tables will populate with the actual data from the data flows but then when I attempt to save it when it comes to the loading data setp I recieve the error message below.  I'm not seeing any errors in the dataflows and the formatting and columns have not changed.  All data sources from existing dataflows which I can access directly and like I said I'm not seeing errors or issues within the dataflow and they are refreshing properly. Loading data OperationCanceled ErrorMessageThe current operation was canceled because one or more operations failed. HttpStatusCode400 Activity ID8e3f57e4-042e-10b4-9b8e-fe79b8f4a59a Request ID0c198856-158e-4886-8e84-756994f51d08 Status code500 Error CodeOperationCanceled Batch ID8e5718cf-1d7f-4d33-bc90-278e0a5b8728@d9edeb66-6d00-456e-a8dd-7682fec3462f$2023-05-02T15:49:50.4829816Z@88e5575b-cbc9-40e4-9e78-8b453e94d6f8 ... View more