Hello Fabric Team,   We are seeing some inconsistencies when using the ROUNDDOWN function. For example, when creating a measure/calculated column with this hardcoded formula:    (1.8-rounddown(1.8, 0))=0.8   The formula evaluates to TRUE, which is correct as 0.8=0.8   However, when we evaluate:   (2.8-rounddown(2.8, 0))=0.8   The formula evaluates to FALSE, which in our opinion is incorrect as 0.8=0.8, no matter how we got there. Please see below for our test tables:   On a call with the Fabric support team (ticket #2404220040008712), we tried and found that the same problem exists even when: We don't harcode the number and use references (columns, other measures) instead We use INT() or TRUNC() instead of ROUNDDOWN() We move the formula to Power Query and use Number.RoundDown instead We use strictly equal == or other operators like <= and >= Our current workaround is to put a ROUND on the left side of the formula, that seems to overcome the issue.   Lastly, not sure if this will help you investigate, but we noticed that the breaking point is between 1.8 and 1.9. Where if the decimal number is below or equal to 1.8 the formula will work properly, while it will not work if the decimal number is above 1.9, with the following exception: For some reason, 1.99 and 1.9999 works (evaluates to TRUE), but 1.9, 1.999, 1.99999 and beyond do not.   Looking forward to hearing back from you!   Regards,   Felix     ... View more

Hi Team,   I noticed a potential bug in PBI Service.  In the Query Editor of PBI Desktop, I'm merging a table multiple times with two other tables (overall 6 merges, first two tables are web sources, third table is an xml-file retrieved from a local drive).   Each merge is performed as a new table and the final table is a reference to the last merge step. Refreshing works in Power BI Desktop, but when uploading and refreshing the semantic model in PBI Service, I'm receiving different error messages - sometimes even resulting in our Gateway going offline. Pls. find an error message example below:   {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Evaluation ran out of memory and can't continue."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}}],"exceptionCulprit":1}}} Table: xxx   I've found a workaround by unchecking "enable load" of all intermediate steps, only enabling load for the final table. Nonetheless, comparing to other queries that we already did it doesn't seem reasonable that loading the merge-steps into the model should result in crashing the gateway.    I hope you can help with this issue. Thanks! ... View more

Running a Copy Data node inside a Data Pipeline, we get the following error message:   ErrorCode=TypeConversionFailure,Exception occurred when converting value '16.12.1985' for column name '33_ColumnName' from type 'String' (precision:, scale:) to type 'Date' (precision:, scale:). Additional info: String was not recognized as a valid DateTime.   However, we are not asking for a converision: What went wrong?   Thanks. ... View more

Hi,   I have one calendar table (french). 12 month : Janvier, Février... Décembre  An integer column [1..12] : 12 values janvier = 1 février = 2... etc. All was working fine and I never had any "duplicate value ..." error message when trying to Sort a column by another one. Version :  2.128.952.0 64-bit (avril 2024)   Regards, Denis ... View more

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