How to customize date formats in my slicer in the online version
Hello, I have this slicer, which allows the end user to filter when the items I am making my report about are published. In the Desktop Version, the format is dd/mm/yyyy, which is what I want. I have also set a column with this date format specified in the desktop app However, when I publish the report in the workspace, the format in the slicer looks like this: Does anyone know how I can specify the date format in the report? My company basically exclusively uses dd/mm/yyyy, so this format will confuse everyone
GA4 - Google Analytics is giving me some troubles at Reading data
Hello, I'm trying to read some data from one of my clients' google analytics account. The problem I have is that I can`t see any database's content. As you see in the image, the database "xxx" is deployed but showing nothing. Am I doing something wrong or just should check a specifict something ? Had anyone had this trouble and solved it? HELP PLEASEconnecting power bi with sql server Stored Procedure error
Feedback Type: Frown (Error) Error Message: Error Stack Trace: Microsoft.Mashup.Client.UI.Shared.ExceptionResultException at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage message) at Microsoft.Mashup.Evaluator.RemoteEvaluationContainerFactory.Container.OnException(IMessageChannel channel, ExceptionMessage message) at Microsoft.Mashup.Evaluator.MessageHandlers.<>c__DisplayClass3_0`1.<AddHandler>b__0(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(IMessageChannel channel, Message message) at Microsoft.Mashup.Evaluator.MessageHandlers.Dispatch(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.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource() at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource() at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource() at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource() at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource() at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_TableSource() at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled) Stack Trace Message: Error Invocation Stack Trace: at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace() at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage) at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e) at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture) at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0() at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.SendAndMarshalExceptions(SynchronizationContext context, Action callback) at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e) at Microsoft.Mashup.Client.UI.Shared.DataImporter.HandleImportEvaluationException(ExceptionResult exceptionView, Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor) at Microsoft.Mashup.Client.UI.Shared.DataImporter.OnGetPreviewResult(PreviewResult preview, Query query, String sourceID, String formulaTitle, Nullable`1 explicitImportDestination, Boolean isNewQuery, Boolean isFromEditor) at Microsoft.Mashup.Client.UI.Shared.DataImporter.GetPreviewResult(Query query, String sourceID, String formulaTitle, Boolean isNewQuery, Boolean isFromEditor, Nullable`1 explicitImportDestination) at Microsoft.Mashup.Client.UI.Shared.DataImporter.<>c__DisplayClass89_0.<OnQuerySettingsResolved>b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass5_0.<Post>b__0(Object null) 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.Delegate.DynamicInvokeImpl(Object[] args) at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj) at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme) at System.Windows.Forms.Control.InvokeMarshaledCallbacks() at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg) at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData) at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context) at System.Windows.Forms.Application.RunDialog(Form form) at System.Windows.Forms.Form.ShowDialog(IWin32Window owner) at Microsoft.PowerBI.Client.Program.<>c.<RunApplication>b__6_8() at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) 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) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleExceptionsWithNestedTasks(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Program.RunApplication(String[] args) at Microsoft.PowerBI.Client.Program.Main(String[] args) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.121.903.0","ModuleName":"","Component":"Microsoft.Mashup.Evaluator.EvaluationHost","Error":"Microsoft.Mashup.Client.UI.Shared.ExceptionResultException","MethodDef":"OnException","ErrorOffset":"","ErrorCode":""} Snapshot Trace Logs: C:\Users\Administrator\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot6c9f872d-a24f-446e-bd9d-a8c57da4ac39.zip Model Default Mode: Import Model Version: PowerBI_V3 Performance Trace Logs: C:\Users\Administrator\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip Enabled Preview Features: PBI_sparklines PBI_scorecardVisual PBI_NlToDax PBI_fieldParametersSuperSwitch PBI_setLabelOnExportPdf PBI_dynamicFormatString PBI_newCard Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_qnaLiveConnect PBI_b2bExternalDatasetSharing PBI_enhancedTooltips PBI_angularRls PBI_onObject PBI_oneDriveSave PBI_oneDriveShare PBI_gitIntegration Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud ExceptionResultMessage: The given key was not present in the dictionary. PowerBIUserFeedbackServices_IsReported: True Formulas: section Section1; shared LocationInfo = let Source = Sql.Databases("4.240.64.61,1232"), z_scope = Source{[Name="z_scope"]}[Data], dbo_LocationInfo = z_scope{[Schema="dbo",Item="LocationInfo"]}[Data] in dbo_LocationInfo; shared LocationContactMatrixMapping = let Source = Sql.Databases("4.240.64.61,1232"), z_scope = Source{[Name="z_scope"]}[Data], dbo_LocationContactMatrixMapping = z_scope{[Schema="dbo",Item="LocationContactMatrixMapping"]}[Data], #"Filtered Rows" = Table.SelectRows(dbo_LocationContactMatrixMapping, each ([ConsigneePerson] = "Y")) in #"Filtered Rows"; shared Clust_ClusterMaster = let Source = Sql.Databases("4.240.64.61,1232"), z_scope = Source{[Name="z_scope"]}[Data] in z_scope; shared Query1 = let Source = DateTimeZone.LocalNow in Source; shared #"Invoked Function" = let Source = Query1(), #"Converted to Table" = #table(1, {{Source}}), #"Split Column by Delimiter" = Table.SplitColumn(Table.TransformColumnTypes(#"Converted to Table", {{"Column1", type text}}, "en-IN"), "Column1", Splitter.SplitTextByDelimiter("+", QuoteStyle.Csv), {"Column1.1", "Column1.2"}), #"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Column1.1", type datetime}, {"Column1.2", type time}}), #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1.2"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Column1.1", "Refresh time"}}) in #"Renamed Columns"; shared #"Wallet Balance" = let Source = Excel.Workbook(File.Contents("C:\Users\Administrator\Desktop\Gainer Sales Dashboard\Wallet Balance.xlsx"), null, true), #"Wallet Balance_Sheet" = Source{[Item="Wallet Balance",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(#"Wallet Balance_Sheet", [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"AccountCode", Int64.Type}, {"AccountNo", type text}, {"CurrentBalance", type number}, {"FundMaintain", Int64.Type}, {"AlertLimit", Int64.Type}, {"AllowableLimit", Int64.Type}, {"Location", type text}, {"Dealer", type text}, {"Brand", type text}, {"PoValButLRNot", type number}, {"ClaimValueRaisedbyMe", Int64.Type}, {"ClaimRaisedonMe", Int64.Type}, {"PaymentInstructionsSenttoBank", Int64.Type}, {"OrderPendingForPOConfirmation", type number}, {"SaleRealisationPending", type number}, {"CrAmount", type any}, {"TrnDate", type text}}) in #"Changed Type"; shared #"Imp Measures" = let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1"}) in #"Removed Columns"; shared #"Imp Measures (2)" = let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1"}) in #"Removed Columns"; shared UAD_Gainer_SalePurchase = let Source = Sql.Database("4.240.64.61,1232", "UAD_BI", [Query="Exec UAD_Gainer_SalePurchase_SP"]), #"Renamed Columns" = Table.RenameColumns(Source,{{"Conf_Time", "Conf_Time(inmin)"}}), #"Merged Queries" = Table.NestedJoin(#"Renamed Columns", {"buyerlocation"}, UAD_GNR_TGT_LW, {"LocationID"}, "UAD_GNR_TGT_LW", JoinKind.LeftOuter), #"Expanded UAD_GNR_TGT_LW" = Table.ExpandTableColumn(#"Merged Queries", "UAD_GNR_TGT_LW", {"Location", "LocationID", "Category", "Responsibility", "Year", "Month", "NMPurchaseMT", "NSPur", "MPur"}, {"UAD_GNR_TGT_LW.Location", "UAD_GNR_TGT_LW.LocationID", "UAD_GNR_TGT_LW.Category", "UAD_GNR_TGT_LW.Responsibility", "UAD_GNR_TGT_LW.Year", "UAD_GNR_TGT_LW.Month", "UAD_GNR_TGT_LW.NMPurchaseMT", "UAD_GNR_TGT_LW.NSPur", "UAD_GNR_TGT_LW.MPur"}), #"Removed Duplicates" = Table.Distinct(#"Expanded UAD_GNR_TGT_LW") in #"Removed Duplicates"; shared UAD_GNR_TGT_LW = let Source = Sql.Database("DESKTOP-1ULGF16", "UAD_Dash_DB_Local", [Query="#(lf)SELECT * FROM UAD_GNR_TGT_LW"]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"BrandID", Int64.Type}, {"DealerID", Int64.Type}, {"LocationID", Int64.Type}}), #"Removed Duplicates" = Table.Distinct(#"Changed Type", {"LocationID"}) in #"Removed Duplicates"; shared #"duplicate measure" = let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}}), #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1"}) in #"Removed Columns"; shared Buying_Potential_Compile_Nov_23 = let Source = Sql.Databases("4.240.64.61,1232"), UAD_BI = Source{[Name="UAD_BI"]}[Data], dbo_Buying_Potential_Compile_Nov_23 = UAD_BI{[Schema="dbo",Item="Buying_Potential_Compile_Nov_23"]}[Data] in dbo_Buying_Potential_Compile_Nov_23; shared Query2 = let Source = Sql.Database("4.240.64.61,1232", "z_scope", [Query="EXEC DBO.USP_rpt_FundsBalance '','','',''"]) in Source;Training Resources for Manufacturing and Quality
Can anyone recommend any YouTube or other training resources for power bi reporting with a focus on maufacturing, technical and quality issues? Seems most of the training out there is geared towards sales and sales trending. Okay some of the senarios can be adapted but it would be easier for me to garner information where it relates more to what I am doing. Currently trying to do complaint trending using two different raw data sources, SAP and SQL (although with the SQL data I am only allowed to connect via access databases!). So having to merge the two lots of production data and skus etc. But would like to see ideal example of star schemas used for this type of trending, to give me some pointers. Currently using a denormalised table scraped from a report in access, along with data provided via launch bi.
Issues with Top 3 as Percentages based on selected filter.
I am having issue with Top 3 Purpose (percentages). Based on selection, The result should be same as on the Purpose Card - 62%, 52% and 38% instead of 67%, 56% and 41%. These top 3 figues should always reflect approximate (rounded) totals in the bar chart as shown. Please select and change Role purpose filter to reconfirm. PBIX: https://1drv.ms/u/s!AlMdRxAveLesgcJZU3xDWUGzxzWWNw?e=f6GlhW
