Hello, The standard summarization is not working. See the count field in the following table: These standard summarization settings: But it is not working.    Does anyone has an idea why?   Thanks.   Maarten   ... View more

Currently, if a certain column "A" in a table is specified as "Key column", then "sort by column" feature - when column "B" is used to sort instead of column "A" - for this column stops working - without any warning or otherwise indication in the UI.   Expected behavior: it should work regardless. ... View more

Hi, When i try to open a file using desktop version im getting this message, how can i open a file on desktop version?   ... View more

I get this issue on pbix open but not every time I open the file. No idea what "findTable" refers to and no idea where to look for an issue.  I think I have seen an increase in this type of      An error occurred while rendering the report. JS Error Message: Cannot read properties of undefined (reading 'findTable')   Glad to share detail in a file (stack trace) as needed.    ... View more

Hello, Since, I updated the Version : 2.127.1080.0 64-bit (mars 2024), I have an issue when I merge 2 tables. In my previous version (October 23), it worked.    I have to merge 2 tables coming from dataflows. The first table is "SAP_operations" and  the second table is "SAP_Routing". I use 3 keys : "routing_number", "routing_group", "activity_type". When I check the first row, the results are correct : I want the index in the SAP_routing that is equal to 1 And when I expand datas, this first row shows index equals to 3.   I tried to join the 2 tables using Numbers or Text but it is the same issue.     Is it possible to give me advices?   ... View more

I have a dataset with column MeetingYrQtr based in meeting date, RegionCode and YrQtrName based on another table with dates.  I want to change my dax PBWithMinsTQtrEXP to calculate total ProjsWithMins when MeetingYrQtr = YrQtrName that I selected from the slicer for example "2024 Q1" is the selected value in YrQtrName slicer it should display 12 as total      The display is wrong when i used this formula  PBWithMinsTQtrEXP = CALCULATE(SUM(PBMins[PrjsWithMins]),PBMins[MeetingYrQtr]= MAX(Dim_Date_ALL[YrQtrName]))       ... View more

Related function not supported in DQ  when used in calculated columns when  databricks is the source and  it gives the below error. But the same dax works this works when synapse is used as the source   dax used in calculated column:-  check = related('MD ORG Company Code'[ORG Company Code Text])   Error:-        ... View more

Hello    After the March 2024 update a Circular Dependency Detected error began to appear in a relationship that seemed to be fine since forever. In fact, the Fabric Service does not issue this error. What's worse, any changes I try to make to the dataset regardless of where the changes are made; this error pops up and completely ignores applying the changes I want to make. Is there a "bug" in the latest Desktop update? Why did this error not exist prior to this? I need help, I can't seem to shake off this issue and I have several updates I need to make to this dataset which cannot be made in the Fabric service. ... View more

Feedback Type: Frown (Error) Timestamp: 2024-04-01T07:13:47.9231300Z Local Time: 2024-04-01T15:13:47.9231300+08:00 Session ID: 73036a34-14b0-4640-a5d6-db8d71254790 Release: April 2024 Product Version: 2.128.352.0 (24.04) (x64) Stack Trace: Host:Microsoft.PowerBI.Client.Windows.PowerBIService.PowerBIServiceException - WebExceptionStatus = ProtocolError, HttpStatusCode = 429 at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification) at Microsoft.PowerBI.Client.Windows.PowerBIService.Flows.AuthenticatedWebRequestor.<>c__DisplayClass6_0.<<MakeWebRequestAsync>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.PowerBIService.Flows.AuthenticatedWebRequestor.<Execute>d__5`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.Services.CopilotSettingsService.<GetCopilotEnabledWorkspacesAsync>d__2.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.ExploreHost.Services.CopilotSettingsHostService.<GetCopilotEnabledWorkspaces>d__3.MoveNext() --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<ProcessInteropCsResults>d__17.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.HostServiceDispatcher.<ExecuteInteropCsMethod>d__15.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.WebView2.WebView2Interop.<>c__DisplayClass22_0.<<InvokeCsMethod>b__0>d.MoveNext() Javascript&colon;HostPromiseError at new InteropPromise (https://ms-pbi.pbi.microsoft.com/pbi/Web/ts/BrowserInteropSetup.js:360:27) at InteropPromises.createPromise (https://ms-pbi.pbi.microsoft.com/pbi/Web/ts/BrowserInteropSetup.js:326:23) at InteropHost.invokeCsFunc (https://ms-pbi.pbi.microsoft.com/pbi/Web/ts/BrowserInteropSetup.js:220:37) at CopilotSettingsHostService.getCopilotEnabledWorkspaces (https://ms-pbi.pbi.microsoft.com/pbi/Web/ts/WebView2InteropServices.js:292:59) at CopilotWorkspacesDesktopService.getCopilotEnabledWorkspaces$ (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:284628:117) at DesktopCopilotWorkspaceService.get (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:284661:69) at CopilotCapabilityService.checkUserCapacity$ (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:361490:135) at SwitchMapSubscriber.project (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:361464:51) at _proto2._next (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:138914:39) at _proto.next (https://ms-pbi.pbi.microsoft.com/minerva/scripts/desktop.js:136678:44) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.128.352.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.PowerBIService.PowerBIServiceProxy","Error":"Microsoft.PowerBI.Client.Windows.PowerBIService.PowerBIServiceException - WebExceptionStatus = ProtocolError, HttpStatusCode = 429","MethodDef":"GetResponse","ErrorOffset":"47","ErrorCode":""} OS Version: Microsoft Windows NT 10.0.22631.0 (x64 en-US) CLR Version: 4.8 or later [Release Number = 533320] Peak Virtual Memory: 71.2 GB Private Memory: 865 MB Peak Working Set: 1.5 GB IE Version: 11.1.22621.0 User ID: 2beb5bcf-a259-4be2-a2e3-7875e7ef8831 Workbook Package Info: 1* - en-CA, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False. Telemetry Enabled: True Model Default Mode: Import Model Version: PowerBI_V3 Enabled Preview Features: PBI_sparklines PBI_scorecardVisual PBI_NlToDax PBI_fieldParametersSuperSwitch PBI_angularRls PBI_backstageUI PBI_setLabelOnExportPdf PBI_dynamicFormatString PBI_oneDriveSave PBI_oneDriveShare PBI_useModernPublishDialogs PBI_gitIntegration PBI_newCard PBI_buttonSlicerAuthoring PBI_useModernMashupEditor PBI_mobileAutoReportLayout PBI_daxQueryView PBI_daxInlineCopilot PBI_aiNarrativesVisual PBI_generateMeasureDescriptionsButton PBI_desktopReportAuthoringCopilot Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_b2bExternalDatasetSharing PBI_enhancedTooltips PBI_onObject PBI_tmdlInDataset PBI_EimLessElevatedUser PBI_modelExplorer PBI_qnaImproveLsdlCopilot PBI_visualCalculationsAuthoring Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: MSIT Recent Actions: ClearFilter, UpdateFilter, UpdateFilter, UpdateFilter, UpdateFilter, UpdateFilter, UpdateFilter, UpdateFilter, UpdateFilter, UpdateFilter, UpdateFilter, UpdateFilter, UpdateFilter, VisualContainerPersistProperties, VisualContainerPersistProperties DPI Scale: 150% Supported Services: Power BI ... View more

Hello, it seems a bug that the DAX would often wrongfully hightlight something that is not an error as error, as you can see from screenshot below with a very simple table of 11 rows. It happens quite often, starting from several release ago (maybe late 2023). Please fix >>    Version: 2.127.1080.0 64-bit (March 2024)   ... View more

I am reporting another serious bug with March release:  - under "Table view" > right-click > copy table function no longer works, it doesn't copy anything   This is the 2nd bug I found with March release within 1 day, what's QA?  ------------------ Version: 2.127.1080.0 64-bit (March 2024)   ... View more

I am reporting a seriuos bug of March 2024 release, example - I created a "Fields parameter" table, which has DAX code behind and was working fine. When I tried to drag one column a bit wider, the entire DAX code simply disappeared!! Now the DAX formula is empty. I had to start from scratch. I have been using March release for 1 day, and it has already happened twice! It has NEVER happened before. I suspect this is because of the new "Copilot" auto-scripting function added to March release. Instead of helping people, it made the entire app worse. Funny thing is I don't need Copilot at all, nor was it enabled.   Can MS look into this? Bug like this ruins product reputation and user confidence.    ---------- Version: 2.127.1080.0 64-bit (March 2024)   ... View more

Today I discovered what appears to either be a bug or some other form of abnormally. The maximum value on a gauge is correct on my desktop but on the cloud Power BI service it appears to have been multiplied by 10. See screenshots below.   Desktop:   Cloud:   Anyone else ever see this behavior? I tried setting the data lables display units to "none" instead of "auto" but this did not resolve the issue. The value is not a measure, it is a simple distinct count for the corresponding records.   Thanks Chris ... View more

I’ve created an account specifically to address an issue that, to my knowledge, has not yet been reported. The 2024 versions of Power BI Desktop have introduced a significant annoyance when working in Table View. My primary concern is the inability to horizontally scroll through columns using arrow keys once a DAX Calculated column is selected. Instead of scrolling, the interface randomly selects and enters the DAX formula bar, preventing further horizontal navigation. This issue also occurs when selecting a DAX Calculated column directly with the cursor, I also have some issues with the message errors telling me there is a duplicate column and the copying of a column Dax code in another Calculated column.   Due to these problems, I’ve reverted to the latest 2023 version of Power BI Desktop, where this issue is absent. The ability to smoothly scroll through columns is crucial for verifying the correctness of DAX code in tables with numerous columns. Unfortunately, the 2024 versions have made it impossible to work efficiently due to this and other issues.   I’m hoping there might be an overlooked option to restore the traditional arrow key scrolling functionality. If not, I hope the development team addresses this bug and reinstate the previous, user-friendly behavior. Thanks. ... View more

Google sheets connector always worked great, never had any issues till now. However since some update in late 2023 yearly 2024 I have been getting this 429 error message stating too many requests were being made and the data simply will not load. I Came to a point when testing this behavior that simply connection to a single sheet with 50 rows returns me this error. so i know the number of sheets connected or the number of rows has nothing to do with it. I have to keep trying and without changing anything at some point it will simply accept and fetch the data normally. But that turns my refreshes unusable, since  they are not reliable and i have to keep refreshing them by hand in order to try multiple times.   I have seen many users reporting similar issues, but no real solution provided until now. If you work with too many sheets some people say to join them all in a single sheet (but as stated that is not the issue here, since a since sheet with 50 rows will get the same error), googles documentation said to do a Exponential backoff  but that cannot be done in pwoerquery (you could do by programming an api but not through power query) and there is no way to increase the limit eitehr by sheets side or PBIs side.   The bulk of the data releis on sheets and this weird behaviour ends up making impossible to use powerbi as is ... View more

Hi all,   I have a Reflex stream in Microsoft Fabric which holds 22 reflexes, based on incoming data. They work fine, however since this morning I am not able to customize/add any of them. Even when trying to just display the data I get the following errors message: Whenever I am trying to update/create a new trigger I get the following error: Without any further information. I already tried clearing my cache and cookies for Fabric, without any results. Any help on diagnosing this issue is appreciated, please reach out if you can point me in the right direction. Kind Regards,   Siebe ... View more

Hi,   Can anyone help me, I cant sign to find out the problem in my Appended table.   Thankyou in advance! ... View more

Hi Team,   In my model I have one fact table and one calendar table both are in direct query mode, also having relation based on date column, however when am trying to create a simple table visual where i have used some columns from fact table and used date fields from calendar table am getting below error.   ... View more

Hi Community,   I'm reaching out regarding an issue I've encountered while connecting Power BI to Snowflake through an ODBC connection. Specifically, I am fetching data from a Snowflake Stored Procedure. The problem arises when I attempt to publish the report and schedule a data refresh from the Semantic Model within the Power BI Workspace. Unfortunately, I've noticed that both the "Refresh" option and the "Data Source Credential" options are faded out for me, preventing me from configuring the refresh settings. I'm uncertain why these options are unavailable, and I'm eager to resolve this issue promptly. If anyone has encountered a similar situation or has any insights into troubleshooting this problem, I would greatly appreciate your assistance. ... View more