I have changed several queries in my Dataflow, but noticed that Data Sources havn't changed. I deleted all queries and created only one simple - Create Blank Table. No Data sources at all. And I still see two Web Data sources when I go to a Diagram View. But they are not in my Query!!! Please help Michael     ... View more

In M, if you adjust the Documentation.FieldDescription and use Value.ReplaceType to apply it, it will be ignored. Other attributes like Documentation.FieldCaption or Documentation.AllowedValues work fine and will be shown, but the FieldDescription will be ignored.   Please see this function for example: https://gist.github.com/ImkeF/9bd1e4d3a9aecc999fb8883c5fd0a318  The command in row 50 will be ignored. ... View more

Hello,    I am connecting to a table through SQL Analysis Server. Within Desktop the table refreshes each time no issues but when I publish to Service, I get the following error message. This has been going on for several days.   Last refresh failed: Mon May 11 2020 09:31:20 GMT-0400 (Eastern Daylight Time) There was an error when processing the data in the dataset.Hide details Data source error: We're sorry, an error occurred during evaluation.;Specified cast is not valid. Specified cast is not valid. Specified cast is not valid.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. Table: Table Name. Cluster URI: DF-MSIT-SCUS-redirect.analysis.windows.net Activity ID: 967384cf-9812-43cd-83a6-05cad7718c86 Request ID: 529b08fb-2e69-7e9f-2f21-47473662f5d2 Time: 2020-05-11 13:31:20Z       I have tried changing the data type Deleted and uploaded a new version to the service Updating my Power BI desktop version  But nothing has worked. Any suggestions? ... View more

Hi what's wrong with MOD() function? When I was checking my solution to this thread https://community.powerbi.com/t5/Desktop/1st-Decimal-Number-needs-to-be-Even/m-p/1081369#M500728 I noticed a very strange behaviour of this function   There is no visual aggregation.   Why the result for even decimal numbers is 0.2, not 0 ? Second point, according https://dax.guide/mod/ and https://docs.microsoft.com/en-us/dax/mod-function-dax it should return me INTEGER and not decimal at all. I feel the bug is somewhere, but where is it? In my head, in DAX, in Power BI DAX engine or in the documentation? ... View more

Hello everyone. If I rename a table (double-clicking the name), in measures that reference that table only the table reference is updated and the column reference does not.   Example: if I have a table "Table 1" and a measure "Measure 1 = summarize('Table 1','Table 1'[Value])" if I rename the table to "Table 2" the measure is updated to "Measure 1 = summarize('Table 2','Table 1'[Value])" instead of  "Measure 1 = summarize('Table 2','Table 2'[Value])"   Using Version: 2.98.683.0 64-bit from the Store.   Many thanks! António.         ... View more

Version: 2.98.683.0 64-bit (October 2021)   Prior to this latest release, all of my Redshift connections were saved in Recent Sources. That is no longer the case.  "Amazon Redshift" appears in the list, but it is not the saved connection. When I select that option, I get an error message. Is this a potential bug or expected behavior? Is there somewhere I should go in Desktop to refresh the sources so this works?       ... View more

Hello everyone,   I have a report that I've refreshed successfully via Power BI Desktop, manual refreshes via the Service, and scheduled refreshes via the service. This morning, the scheduled refresh failed due to a circular dependency. I refreshed successfully via the Desktop version. Any ideas as to why?   [% diff], [tunnel forecast Downstream], and [tunnel forecast sales] are all calculated (DAX) columns. [% diff] is calculated using the other two calculated columns   Data source error: A circular dependency was detected: schn vw_SalesForecast[tunnel forecast Downstream], schn vw_SalesForecast[% diff], schn vw_SalesForecast[tunnel forecast sales], schn vw_SalesForecast[tunnel forecast Downstream]. Cluster URI: WABI-NORTH-EUROPE-F-PRIMARY-redirect.analysis.windows.net Activity ID: 4302928e-aa2b-433c-a9b0-c8708c041d56 Request ID: 744158ad-5ca7-fcdc-0e13-b94200de883e Time: 2021-10-22 14:22:54Z ... View more

Upon the latest update to Power BI, ALL of my reports have their data models scrambled upon opening. Instead of the nice layout with lookup tables and main data tables, everything is organized in a scrambled star schema. If I rearrange how I like to view them and save, it does no good as when I open the file back up the next time, it is completely scrambled again. This is terrible for complex data models and trying to make sure relationships and structures are setup exactly how you want them. PLEASE FIX. ... View more

I am getting this error when trying to connect to an Excel file from a SharePoint:       Feedback Type: Frown (Error) Timestamp: 2021-10-20T23:16:40.8317375Z Local Time: 2021-10-20T18:16:40.8317375-05:00 Session ID: e1e29dd6-8e8c-407a-9787-81d2fb83bfd7 Release: October 2021 Product Version: 2.98.683.0 (21.10) (x64) Stack Trace: System.NullReferenceException at Microsoft.Mashup.Client.UI.Shared.Controllers.JsonOAuthCredentialData..ctor(TokenCredential credential) at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.ChallengeFloatingDialogBase.JsOAuthDialogResult.ToJson(OAuthDialogResult oAuthDialogResult) at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.ChallengeFloatingDialogBase.InvokeChallengeOAuthDialogCallback(IJsHostedScript jsHostedScript, OAuthDialogResult oAuthDialogResult) at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.98.683.0","ModuleName":"Microsoft.Mashup.Client.UI.dll","Component":"Microsoft.Mashup.Client.UI.Shared.Controllers.JsonOAuthCredentialData","Error":"System.NullReferenceException","MethodDef":".ctor","ErrorOffset":"0"} OS Version: Microsoft Windows NT 10.0.19043.0 (x64 en-US) CLR Version: 4.7 or later [Release Number = 528372] Peak Virtual Memory: 122 GB Private Memory: 2.8 GB Peak Working Set: 3.21 GB IE Version: 11.789.19041.0 User ID: 719ba1c1-969d-4d21-a1e8-4f92d7c6ca84 Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Model Default Mode: Import Model Version: PowerBI_V3 Enabled Preview Features: PBI_shapeMapVisualEnabled PBI_qnaLiveConnect PBI_azureMapVisual PBI_dataPointLassoSelect PBI_dynamicParameters PBI_enhancedTooltips PBI_rdlNativeVisual Disabled Preview Features: PBI_SpanishLinguisticsEnabled PBI_compositeModelsOverAS Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BI ... View more

Mmmm , another problem with the October Update - Worked fine before - why doesn't it work now?     ... View more

I have recently been unable to connect to any new Sharepoint sources in my Power BI reports. The existing connections that I have built continue to work, but any new connections result in the following error:   There are no further details with the error, making troubleshooting difficult. I have attempted using the Sharepoint folder, Web, and Excel Workbook connectors and all result in the same error. I have attempted uninstalling/reinstalling Power BI Desktop as well as clearing my permissions, but nothing has worked. I have also tried recreating the existing Sharepoint connections that I have in my report and they fail (but the existing connections still successfully refresh).   I am using version 2.98.683.0 of Power BI Desktop. ... View more

All of a sudden all of my automatic refreshes have been failing due a message "Your data source can't be refreshed because the credentials are invalid." Nothing has changed and I don't know why I am receiving this message.    I click on Edit Credentials (Salesforce credentials) and unable to do so because now I'm receiving this message "Failed to update data source credentials: We're sorry, an error occurred during evaluation".   This was all working fine a couple of days ago and yesterday, I started running into the refresh issue. I have deleted my cache, cookies, etc. but I am unable to edit my Salesforce creditials.   Anyone have any ideas / thoughts?   Thank you!     ... View more

I have two dataflows that have been working for months and still refresh successfully. The issue I have is that when editing either of them now, then clicking save and close, I get an error message saying 'An error occurred whilst validating your queries' after a few minutes.  This even happens when making no changes at all to the existing data flow and just clicking 'Save and Close', suggesting that either... the validation process has changed since this was last done successfully  there is a wider problem impacting both dataflows  I am able to see a preview of all tables before with no errors before clicking Save and Close so can't narrow it down to any issue with a particular table. This means I can't edit develop either data flow beyond their current state and seems too much of a coincedence that both are experiencing the same issue all of a sudden.    The fact this error occurs so quickly seems to suggest it isn't a memory issue.   Has anyone experienced this issue too recently?   Thanks ... View more

How to diplay amounts / numbers in Crores and Lakhs? I have configured a numeric field in the Power BI Desktop under Modeling tab -> Properties -> Format: Rs. English (India). It displays correctly. After I publish the report, comma gets set to Millions in Power BI web interface. My Windows 10 Region ->  digit grouping and currency settings are also correct.  ... View more