November update removed an option to horizontally align an individual value in New Card, the option is now only available to Series = All.  This blocks new development of our report. ... View more

Hi all,   Very strange thing here. I'd like to visualize my project locations. Saudi Arabia is shortened as SA and shown correctly on desktop app and the web, but in PowerPoint, it places the pin on South Africa. Databases are the same, values are the same, same visual, same abbreviation... How come?               ... View more

Hi all   When I add a PowerBI to a PowerPoint, it works as expected for the first time, and refreshes without a problem. But if I add a new visual to the same PowerBI, or apply a new filter and publish again, filters are not synced with the Powerpoint add-in and show the new/updated visuals without a filter. Possibly URL is generated with the filters the first time and then does not recognize any change afterwards about the filters. Any idea how to overcome this?   Scenario for better understanding:   I am presenting metrics for projects only A, C, D from the projects pool A, B, C, D, E. I copy the URL and add it to the PowerBI tile in PowerPoint. Works as expected. For the next month, I'd like to add our new project "F" to the same PowerBI page. I update the project filter visual to include "F". On the desktop and web workspace, everything works and can change between projects A, C, D, F. On the PowerPoint side, F does not show up and keeps the original filters from when I copied the URL.   ... View more

While wanting to change the font size in a text box, the sizes appear on my 2nd monitor, really far away of the text box... Is it a bug or a wrong configuration somewhere from my side? it would be nice if it could stay on the same screen 🙂   I'm training a bit in the nice Maven Challenge 🙂       ... View more

I like to divide SumTenantKWH with SumUtilityKWH from from image , which is already calculated measure  for each Facility from 2 different output tables (TenantKWH,UtilityKWH)     From the image facility=DFW01  SumTenantKWH(4681698.36) /  facility=DFW01 SumUtilityKWH(7,339.50) = 628.4581   facility=IAD01  SumTenantKWH(49,742,427.00) /  facility=DFW01 SumUtilityKWH(64,619,748) = 0.769771   Any help will be appreciated... Thanks  ... View more

I have two Error messeges:   1.Feedback Type: Frown (Error) Timestamp: 2023-11-30T12:52:09.0793404Z Local Time: 2023-11-30T14:52:09.0793404+02:00 Session ID: a884f3b6-7e03-4f52-aadb-5e0c94963bed Release: November 2023 Product Version: 2.123.742.0 (23.11) (x64) Stack Trace: System.BadImageFormatException at System.Runtime.Serialization.Json.DataContractJsonSerializer.Initialize(Type type, IEnumerable`1 knownTypes, Int32 maxItemsInObjectGraph, Boolean ignoreExtensionDataObject, IDataContractSurrogate dataContractSurrogate, EmitTypeInformation emitTypeInformation, Boolean serializeReadOnlyTypes, DateTimeFormat dateTimeFormat, Boolean useSimpleDictionaryFormat) at Microsoft.Data.Mashup.Preview.DownloadManifestResult.FromDownloadResponse(Stream manifest, Version targetEngineVersion, IHostTrace trace) at Microsoft.Data.Mashup.Preview.MashupExtensionsServiceClient.GetRemoteExtensionManifest(String remoteExtensionUrl, MashupExtensionsServiceState state, MashupExtensionsServiceClientCancellationToken cancelled, IEvaluationConstants evaluationConstants) at Microsoft.Data.Mashup.Preview.MashupExtensionsServiceLibraryProvider.FetchRemoteExtensionManifest(MashupExtensionsServiceState serviceState) at Microsoft.Data.Mashup.Preview.MashupExtensionsServiceLibraryProvider.<>c__DisplayClass45_0.<ConfigureManifestPolling>b__1() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.123.742.0","ModuleName":"Microsoft.Data.Mashup.Preview.dll","Component":"Microsoft.Data.Mashup.Preview.DownloadManifestResult","Error":"System.BadImageFormatException","MethodDef":"FromDownloadResponse","ErrorOffset":"0","ErrorCode":""} OS Version: Microsoft Windows NT 10.0.22621.0 (x64 uk-UA) CLR Version: 4.8 or later [Release Number = 533320] Peak Virtual Memory: 70.2 GB Private Memory: 235 MB Peak Working Set: 645 MB IE Version: 11.1.22621.0 User ID: 4c310060-f68c-4844-b597-3eaca633004b Telemetry Enabled: True DPI Scale: 100% Supported Services: Power BI   2.  Feedback Type: Frown (Error) Timestamp: 2023-11-30T12:57:40.0058812Z Local Time: 2023-11-30T14:57:40.0058812+02:00 Session ID: a884f3b6-7e03-4f52-aadb-5e0c94963bed Release: November 2023 Product Version: 2.123.742.0 (23.11) (x64) Stack Trace: Microsoft.PowerBI.Client.Windows.Storage.FileOpenException at Microsoft.PowerBI.Client.Windows.Storage.FileOpenError.HandleError(IWindowService windowService, LocalizedString title) at Microsoft.PowerBI.Client.Program.TryOpenOrCreateReport(IPowerBIWindowService windowService, ICurrentFileManager currentFileManager, IFileHistoryManager fileHistoryManager, CommandLine commandLine, FileType fileType, IFileInformationProtectionManager fileInformationProtectionManager, IPowerBITelemetryService telemetryService) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_0.<RunApplication>b__0() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.123.742.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenError","Error":"Microsoft.PowerBI.Client.Windows.Storage.FileOpenException","MethodDef":"HandleError","ErrorOffset":"250","ErrorCode":"DataModelLoadFailed"} InnerException0.Stack Trace: at Microsoft.PowerBI.Lucia.LinguisticSchemaContainer.UpgradeIfNeeded(Func`1 getConceptualSchema, String defaultContent, Func`2 doAdditionalUpgrades) at Microsoft.PowerBI.ExploreHost.Lucia.ReportLinguisticSchema.CreateEmpty(Boolean useLegacyXml, Boolean useLsdlDocument) at Microsoft.PowerBI.Client.Windows.Report..ctor(PackagePath packagePath, String reportViewDocumentContent, String reportMobileStateContent, ReportVersionCompatibilityFlags versionCompatibility, DiagramLayoutVersionCompatibilityFlags diagramLayoutVersionCompatibility, ConnectionsSettings connectionSettings, CustomVisualCollection customVisuals, String diagramViewState, ReportLinguisticSchema linguisticSchema, ReportSettings reportSettings, StaticResourceCollection staticResources, String diagramLayout, Byte[] customProperties, String artifactSessionInfo, DaxQueryViewState daxQueryViewState) at Microsoft.PowerBI.Client.Windows.Services.CurrentFileManager.<OpenNew>d__27.MoveNext() InnerException1.Stack Trace: at System.Xml.Serialization.XmlReflectionImporter.ImportTypeMapping(TypeModel model, String ns, ImportContext context, String dataType, XmlAttributes a, Boolean repeats, Boolean openModel, RecursionLimiter limiter) at System.Xml.Serialization.XmlReflectionImporter.ImportElement(TypeModel model, XmlRootAttribute root, String defaultNamespace, RecursionLimiter limiter) at System.Xml.Serialization.XmlReflectionImporter.ImportTypeMapping(Type type, XmlRootAttribute root, String defaultNamespace) at System.Xml.Serialization.XmlSerializer..ctor(Type type, String defaultNamespace) at Microsoft.Lucia.Core.ModelLinguisticSchema..cctor() InnerException2.Stack Trace: at System.Reflection.CustomAttribute.GetCustomAttributes(RuntimeModule decoratedModule, Int32 decoratedMetadataToken, Int32 pcaCount, RuntimeType attributeFilterType, Boolean mustBeInheritable, IList derivedAttributes, Boolean isDecoratedTargetSecurityTransparent) at System.Reflection.CustomAttribute.GetCustomAttributes(RuntimePropertyInfo property, RuntimeType caType) at System.Xml.Serialization.XmlAttributes..ctor(ICustomAttributeProvider provider) at System.Xml.Serialization.XmlReflectionImporter.GetAttributes(MemberInfo memberInfo) at System.Xml.Serialization.XmlReflectionImporter.InitializeStructMembers(StructMapping mapping, StructModel model, Boolean openModel, String typeName, RecursionLimiter limiter) at System.Xml.Serialization.XmlReflectionImporter.ImportStructLikeMapping(StructModel model, String ns, Boolean openModel, XmlAttributes a, RecursionLimiter limiter) at System.Xml.Serialization.XmlReflectionImporter.ImportTypeMapping(TypeModel model, String ns, ImportContext context, String dataType, XmlAttributes a, Boolean repeats, Boolean openModel, RecursionLimiter limiter) InnerException3.Stack Trace: 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.Reflection.CustomAttribute.GetCustomAttributes(RuntimeModule decoratedModule, Int32 decoratedMetadataToken, Int32 pcaCount, RuntimeType attributeFilterType, Boolean mustBeInheritable, IList derivedAttributes, Boolean isDecoratedTargetSecurityTransparent) InnerException4.Stack Trace: at System.Runtime.Serialization.DataMemberAttribute.set_Order(Int32 value) OS Version: Microsoft Windows NT 10.0.22621.0 (x64 uk-UA) CLR Version: 4.8 or later [Release Number = 533320] Peak Virtual Memory: 70.2 GB Private Memory: 226 MB Peak Working Set: 645 MB IE Version: 11.1.22621.0 User ID: 4c310060-f68c-4844-b597-3eaca633004b Telemetry Enabled: True DPI Scale: 100% Supported Services: Power BI ... View more

We have an issue caused by certain dataflows and datasets refreshing at the same time. Our capacity seems frozen. We get this error message: Unable to complete the action because your organization's Fabric compute capacity has exceeded its limits. Try again later. See https://go.microsoft.com/fwlink/?linkid=2247526 to learn more. No relative documentation anywhere. What can we do to solve this? ... View more

Dear experts referring to my post maybe someone can look into it. I got a new notebook and installed PowerBI Desktop from the Microsoft Store. I then loaded the working PBIX file and wanted to save it or publish it. Both doesn't work and errors are raised by Power BI Desktop. Refreshing the data and showing the report dashboard works. What can be the problem? ... View more

Hello everyone, Several users have reported they can't access PBI web service since Monday Nov 27th. Some of them confirmed that clearing the cache and cookies helped, but not all of them so the problem still exists. Is there any known reason for this situatuin? Any advice? Thanks in advance!   ... View more

When using Alt shortcut keys in Power BI Desktop, I've noticed that the View/Filters (F) remains on-screen and won't go away until you close and reopen Power BI Desktop.     ... View more

Hello!   A week ago I published a working BI model the Fabric with no issues.  This week the Power Query data model in Power BI Desktop Version: 2.123.742.0 64-bit (November 2023) will not load into the report with this error:   Failed to save modifications to the server. Error returned: 'DirectQuery partition <Table><GUID> has '0' datasource reference(s) in its expression which is not allowed. '.  The tables it's complaining about all refer to Direct Query tables in the model (the Reference option in the query editor).  Until yesterday these all parsed/loaded just fine.  I'm facing having to rebuild the entire PBIX, as deleting the tables or making any change to the data model always produces the above error.  I've Bing'ed the issue of course   Any help appreciated, many thanks!   Neil ... View more

We are embedding PowerBI reports in Web Applications. We track who the relevant user is using such PowerBI embedded reports by virtue of for whom the relevant embed token was generated. This used to be part of the data in the Activity Log. => Using the powershell Get-PowerBIActivityEvent (or the REST API version). For the Activity = "GenerateEmbedToken" an array was returned in the JSON object named: RLSIdentities. e.g.       { "activityEventEntities": [ { "Id": "3be****", "RecordType": 20, "CreationTime": "2021-08-24T10:18:08", "Operation": "GenerateEmbedToken", "OrganizationId": "95****", "UserType": 6, "UserKey": "5e********", "Workload": "PowerBI", "UserId": "5e******", "Activity": "GenerateEmbedToken", "ItemName": "Consultant Dashboard", "WorkSpaceName": "Sales", "DatasetName": "Consultant Dashboard", "ReportName": "Consultant Dashboard", "CapacityId": "63*********", "CapacityName": "p*****", "WorkspaceId": "56********", "ObjectId": "Consultant Dashboard", "DatasetId": "ad********", "ReportId": "a9**********", "EmbedTokenId": "42*********", "RLSIdentities": [ { "Username": "jane.doe", "Roles": [ "All" ], "Datasets": [ "ad********" ] } ], "IsSuccess": true, "ReportType": "PowerBIReport", "RequestId": "f3*********", "ActivityId": "00********", "DistributionMethod": "Shared" } ], "continuationUri": "https://wabi-europe-north-b-redirect.analysis.windows.net/v1.0/myorg/admin/activityevents?continuationToken='LD************'", "continuationToken": "LD***********", "lastResultSet": false }       This array is no longer returned.  What changed? What can be done to have it returned in the event data?   ... View more

Hi Guys, I saw the Answer on how to convert negative to positive values and I did it ! Now I have new column with positive values ( which are Ex negative values) Now I try to use formula SUM to sum up the values, no error in measure. But when I put the measure in Visual, it shows blank.  I already corrected the Data type: Decimal Number (which is true) and Format: Currency, and Summarization: SUM Nothing helps. Please help! ... View more

I'm trying to deploy a datamart using the deployment pipeline from our development workspace to our test workspace but the deployment seems to fail.    The deployment UI gives a generic error ( Something went wrong, Deployment couldn't be completed. )   I managed to open the datamart in the test workspace before it get deleted and the error displayed is   Tabular databases do not support CompatibilityLevel downgrade. Current CompatibilityLevel: '1604'. Requested CompatibilityLevel: '1561'.   It seems that the newly created datamart is set to level 1604 and the development datamart is level 1561.   Is this a known issue? It makes it impossible to deploy the datamart to the next stage which seems to be a huge issue long term.   Thanks ... View more

As of the latest update, the matrix visual will no longer render in Chrome after publishing to app.powerbi.com.  This was tested on four workstations at our organization.  The matrix displays fine in Power BI Desktop and Edge but is completely invisible in Chrome.  It appears that the matrix is the only affected visual. ... View more

Hi guys, I noticed a bug where visuals would change their size by a couple of pixels when I move them around on the canvas. Button visual before i move it: Button visual after I move it:   ... View more

Hello, I have discovered an issue with the new Save As and first time Save window. The GUI implies that files are being saved as ".pbix". However, if you enter a file name that has a "." in it, the file will be saved as a file type of whatever is after the ".". For example, I have saved a file called "Report v1.12" and it has saved the file as a file type of "12". The user can resolve this by adding ".pbix" to their file name, but the GUI is misleading the user into thinking that ".pbix" is being added automatically --- surely this is a simple fix!   I'm on desktop version 2.122.1066.0 64 bit   ... View more

Our app was working fine till yesterday. But today without any change dataSelected event is not getting fired for some users whereas its fine for others. WE have our react app deployed in prod. It has embedded power bi report integrated. We have a button which gets enabled when we select an item from report grid.  This item selection is supposed to fire dataSelected event of power bi report but its not firing suddenly. Whereas if we click on any other slicer or filter , the dataSelected event gets fired. How is the issue happening suddenly today without any change?   ... View more

https://app.powerbi.com/  doesn not load "The serice is unavailable"   or https://app.powerbi.com/ErrorPage?code=403&errorType=AppMetadataInaccessible&raid=f27a076f-0f59-4714-8324-512dbbe2d727     embedded reports do not load, or sometimes will load but can take a very long time   I'm Currently located on in New zealand and have tested on different networks ... View more