Images on first page of embedded report flicker and disappear
I have an Image URL visualization which shows an image of the company that is selected in a slicer. It is live on https://www.talkingengagement.ca/municipal-culture-indicators All my images are publicly hosted URLs, in the right format. They all work except for the first image that loads by default. That image flickers in and out, and sometimes disappears completely. The data responds perfectly to the slicer, the flickering problem is only with the image. I tried to troubleshoot by changing the image, changing the number and order of companies in my data; the problem is always with whichever image is loaded first. In powerBI Desktop and MyWorkspace, everything is fine. The problemarises when the report is embedded, on all browsers. The problem is intermittent
Fabric Lakehouse Shortcut does not refresh Variable Library target after active value set change
I am using a Microsoft Fabric Lakehouse shortcut whose target is configured through a Variable Library variable. The Variable Library contains separate value sets for Dev and Prod. In the Prod workspace, the Prod value set is active and contains the correct target Lakehouse/path. However, the shortcut still points to the Dev target even though the Prod value set is active. When I open the shortcut configuration in the Lakehouse UI, edit the shortcut, and save it once without changing the actual value, the shortcut immediately resolves correctly to the Prod target. This makes it look like the shortcut target is cached or materialized and is not automatically refreshed from the currently active Variable Library value set after switching value sets or after deployment. The Variable Library value itself seems to be correct, because manually editing and saving the shortcut fixes the issue without any real configuration change. Expected behavior: A Lakehouse shortcut that uses a Variable Library variable for its target should always resolve to the value from the currently active value set in the workspace. If the Prod value set is active, the shortcut should point to the Prod target. Actual behavior: The shortcut continues to point to the Dev target although the Prod value set is active. Only after manually editing and saving the shortcut does it resolve to the correct Prod target. Impact: This is risky for deployment scenarios because a Prod Lakehouse shortcut can still reference Dev data until somebody manually opens and saves the shortcut. This can lead to accidental use of data from the wrong environment. Workaround: Opening the shortcut configuration and saving it once seems to refresh the resolved target. However, this manual step is easy to miss and not suitable for reliable deployment or CI/CD processes. Has anyone else seen this behavior with Lakehouse shortcuts and Variable Libraries? Is this a known limitation, a caching issue, or a product bug?
Power Bi Login nao funciona
Pessoal, boa noite. Já faz um tempo que estou enfrentando esse problema e agradeço se alguém puder me ajudar. Estou tentando fazer login utilizando qualquer e-mail, mas não consigo. Depois que clico em "Entrar", simplesmente nada acontece. Não aparece nenhuma mensagem de erro, apenas permanece na mesma tela. Alguns pontos importantes: * Esse problema acontece com frequência no computador da empresa onde trabalho e, hoje, também começou a acontecer no computador da minha casa. * Já alterei a autenticação para utilizar o navegador padrão. * Já tentei praticamente tudo: limpei o cache, desinstalei e reinstalei o Power BI Desktop, instalei pela Microsoft Store e também testei versões anteriores do Power BI Desktop. Nada resolveu. * Consigo acessar normalmente todos os serviços da Microsoft, incluindo Power BI Service, Microsoft 365, Azure e os demais sites da Microsoft. O problema acontece exclusivamente no Power BI Desktop. * O mais estranho é que, sempre que formato a máquina, o Power BI Desktop funciona normalmente por alguns dias. Depois de um tempo, ele simplesmente faz o logout da conta e não consigo mais fazer login. Alguém já passou por esse problema ou sabe o que mais posso testar? Obrigado!
Data Warehouse - Restoring to restore point via API - Fabric UI bug
As part of our CICD deployment pipelines (using GitHub workflow), pre deploying our 3 Data Warehouse dacpacs, we call the Fabric API to create restore points for each. If there are any failures during the dacpac deployments, we call the Fabric API using a service principle (which has admin access to the workspace), to restore to these restore points we've just created. This restores it back to the correct restore point, however when we then open the warehouse in the fabric UI and open the restore points list, it throws the following error and the list is blank: Cannot read properties of undefined (reading 'displayName') I can still call the Fabric API to list the restore points of the warehouse and it returns the correct list, it's just not accessible through the Fabric UI. Seems to be a Fabric UI bug, as the restore points we are creating look perfectly valid (see the CICD Deployment one below). { "value": [ { "id": "[redacted]", "displayName": "Restore point", "description": "", "creationMode": "SystemCreated", "creationDetails": { "eventDateTime": "2026-06-10T11:37:57Z", "eventInitiator": null } }, { "id": "[redacted]", "displayName": "CICD Deployment 20260610-132753", "description": "Restore point created before DACPAC publish.", "creationMode": "UserDefined", "creationDetails": { "eventDateTime": "2026-06-10T13:28:39Z", "eventInitiator": { "id": "[redacted]", "type": "ServicePrincipal" } } } ] } Looks more like the system created restore point could be the cause of this, perhaps the null event initiator is not handled. Unfortunately I do not have a screenshot of the error anymore, as I've backed out the code to restore automatically during deployment and have deleted and recreated the problem warehouse. Just imagine the below has no items in the list (even though the are there...).. and a little error box comes up with: Cannot read properties of undefined (reading 'displayName') If need be, I can re-create the issue again and get the error. Let us know. Thanks.
Falha na atualização credencial fonte de dados Planner
Só consigo atualizar os dados no Power BI Desktop, no versão online dá este erro acima. Já tentei mudar para anônimo, mas não deu certo! Já tentei colocar credenciais do Windowns, porém não tive exito também. Minha requisição é do planner e utilizei esse código: https://graph.microsoft.com/v1.0/planner/plans/{id}/tasks Utilizei um relativepath no {id} e resolvi um problema de dados dinâmicos, mas na hora de configurar para atualizar ou agendar não consigo.Issues with changing the workspace ID when versioning.
I'm working on versioning the changes in my workspace in a Git repository. My production workspace (PROD) is linked to the main branch. I have other development workspaces (DEV) that represent other branches. In the production workspace, in addition to the lakehouses, I also have a database, and I want to consume information from this database in the other branches as well. To do this, I created a shortcut to the database schema (from the main branch workspace) in the lakehouse of the DEV workspace. However, whenever I make a Pull Request transferring changes from the DEV branch to the PROD branch, Fabric modifies the shortcuts.metadata.json file... keeping the Workspace ID as "workspaceId": "00000000-0000-0000-0000-000000000000", and changing parameters.... Because of this, I can never get the DEV and PROD branches synchronized, since Fabric changes the parameters... There's always a pending change in the main branch (PROD) that was supposedly made in the main branch itself, which is not a good practice for versioning code...GetAppUsersAsAdmin API- Audience Support
We regularly use the GetAppUsersAsAdmin API endpoint to obtain a list of users that have access to an App. With the new App experience and addition of 'Audiences' , is there or will there be a way to differentiate which users belong to which audience, because currently we just see a list of all users for the app regardless of the audience they belong to?
DateTime Error for Adobe Analytics Connector 2.0
I'm getting a new error back from the Adobe Analytics connector 2.0. It says that the string was not recognized as a valid DateTime. The weird thing is that this happened to an existing report that's been working for months. It appears to be tied directly to the Date Granularity portion of the code: section Section1; shared #"xxxxxxxxxxx" = let Source = AdobeAnalytics.Cubes([HierarchicalNavigation=true]), xxxx = Source{[Name="xxx"]}[Data], xxxxxxxxx = xxx{[Id="xxx"]}[Data], #"Added Items" = Cube.Transform(xxx, { {Cube.ApplyParameter, "DateRange", {#date(2022, 6, 8), #date(2022, 6, 8)}}, {Cube.AddAndExpandDimensionColumn, "DateGranularity", {"year", "month", "day"}, {"Date Granularity.Level 1: Year", "Date Granularity.Level 2: Month", "Date Granularity.Level 3: Day"}}, {Cube.AddMeasureColumn, "Visits", "visits"} }) in #"Added Items"; shared #"NavigatorBase_c824bbff-c5c4-4018-a767-e917f280cc3e" = let Source = AdobeAnalytics.Cubes([HierarchicalNavigation=true, Implementation="2.0"]) in Source; error details below: Feedback Type: Frown (Error) Timestamp:2022-06-08T17:54:12.2780074Z Local Time:2022-06-08T13:54:12.2780074-04:00 Session ID:dbfe88b2-189d-4606-9878-1e7ccc333c54 Release:May 2022 Product Version:2.105.1143.0 (22.05) (x64) Stack Trace: Microsoft.Mashup.Host.Document.SerializedException Microsoft.Mashup.Evaluator.Interface.ErrorException: String was not recognized as a valid DateTime. ---> Microsoft.Mashup.Evaluator.Interface.ErrorException: String was not recognized as a valid DateTime. ---> System.FormatException: String was not recognized as a valid DateTime. ---> System.FormatException: String was not recognized as a valid DateTime. at Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsDateGranularityHierarchyV2.<>c.<.cctor>b__9_0(String s) at Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsReportDescriptionV2.AdobeAnalyticsReportDescriptionV2NonSegment.GetReportRows(RecordValue dataRecord, AdobeAnalyticsServiceV2 service, String companyId) at Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsReportDescriptionV2.AdobeAnalyticsReportDescriptionV2NonSegment.<GetReportNonZeroDimensions>d__27.MoveNext() at Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsResultEnumeratorV2.TryIncrementEnumerators(Int32 depth) at Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsResultEnumeratorV2.MoveNext() at Microsoft.Mashup.Engine1.Runtime.SkipTakeEnumerator`1.MoveNext() at System.Linq.Buffer`1..ctor(IEnumerable`1 source) at System.Linq.Enumerable.ToArray[TSource](IEnumerable`1 source) at Microsoft.Mashup.Engine1.Runtime.Library.List.BufferFunctionValue.TypedInvoke(ListValue list) at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue1`2.Invoke(Value arg0) at Microsoft.Mashup.Engine1.Runtime.TableValue.BufferedTableValue.BufferTable(TableValue table) at Microsoft.Mashup.Engine1.Runtime.TableValue.Buffer(BufferMode bufferMode) at Microsoft.Mashup.Engine1.Runtime.WrappingTableValue.Buffer(BufferMode bufferMode) at Microsoft.Mashup.Engine1.Library.Table.TableModule.Table.BufferFunctionValue.TypedInvoke(TableValue table, Value options) at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue2`3.Invoke(Value arg0, Value arg1) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.FunctionInvocationInstruction2.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.DebugInstruction.Execute(MembersFrame1& frame) at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Runtime.Library.Linker.BindFunctionValue.TypedInvoke(RecordValue environment, Value section, TextValue name) at Microsoft.Mashup.Engine1.Runtime.NativeFunctionValue3`4.Invoke(Value arg0, Value arg1, Value arg2) at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke() at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.Force(Int32 index) at Microsoft.Mashup.Engine1.Language.ListInstruction.RuntimeListValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Language.MembersFunctionValue1.Invoke(Value arg0) at Microsoft.Mashup.Engine1.Language.RecordInstruction.RuntimeRecordValue.get_Item(Int32 index) at Microsoft.Mashup.Engine1.Language.MembersFunctionValue0.Invoke() at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception) at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(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.EvaluationHost.Run() at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args) at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o) at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args) at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass3_0.<BeginGetResult>b__0(EvaluationResult2`1 result) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.<>c__DisplayClass3_0.<BeginGetResult>b__0(EvaluationResult2`1 result) at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.SimpleDocumentEvaluator.BeginGetResult(DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallPartition.BeginGetResult[T](Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.Evaluation`1.OnBufferComplete(Exception exception) at Microsoft.Mashup.Evaluator.Firewall.BeginBufferPartitions(Action`1 callback) at Microsoft.Mashup.Evaluator.FirewallDocumentEvaluator.BeginGetResultInternal[T](DocumentEvaluationParameters parameters, Action`1 callback) at Microsoft.Mashup.Evaluator.Interface.IDocumentEvaluatorExtensions.GetResult[T](IDocumentEvaluator`1 evaluator, DocumentEvaluationParameters parameters) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(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.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(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.EvaluationHost.Run() at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args) at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o) at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args) at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass9_1.<OnBeginGetPreviewValueSource>b__1() at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.<>c__DisplayClass0_0.<RunStub>b__0() at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.EvaluationHost.<>c__DisplayClass17_0.<TryReportException>b__1() at Microsoft.Mashup.Common.SafeExceptions.IgnoreSafeExceptions(IEngineHost host, IHostTrace trace, Action action) at Microsoft.Mashup.Evaluator.EvaluationHost.TryReportException(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Exception exception) at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action) at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.RunStub(IEngineHost engineHost, IMessageChannel channel, Func`1 getPreviewValueSource) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.<>c__DisplayClass12_1`1.<OnBeginGetResult>b__0() at Microsoft.Mashup.Evaluator.EvaluationHost.ReportExceptions(IHostTrace trace, IEngineHost engineHost, IMessageChannel channel, Action action) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetResult[T](IMessageChannel channel, BeginGetResultMessage message, Action`1 action) at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.Service.OnBeginGetPreviewValueSource(IMessageChannel channel, BeginGetPreviewValueSourceMessage message) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(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.ChannelMessenger.OnMessageWithUnknownChannel(IMessageChannel baseChannel, MessageWithUnknownChannel messageWithUnknownChannel) at Microsoft.Mashup.Evaluator.MessageHandlers.TryDispatch(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.EvaluationHost.Run() at Microsoft.Mashup.Container.EvaluationContainerMain.Run(Object args) at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o) at Microsoft.Mashup.Container.EvaluationContainerMain.SafeRun(String[] args) at Microsoft.Mashup.Container.EvaluationContainerMain.Main(String[] args) --- End of inner exception stack trace --- at Microsoft.Mashup.Evaluator.EvaluationHost.OnException(IEngineHost engineHost, IMessageChannel channel, ExceptionMessage 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_Value() at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_Value() at Microsoft.Mashup.Host.Document.Preview.PreviewEvaluation.<>c__DisplayClass22_0.<StartEvaluation>b__0(EvaluationResult2`1 result) PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.105.1143.0","ModuleName":"","Component":"Microsoft.Mashup.Engine1.Library.AdobeAnalytics.V2.AdobeAnalyticsDateGranularityHierarchyV2.<>c.<","Error":"System.FormatException","MethodDef":"cctor>b__9_0","ErrorOffset":""} OS Version: Microsoft Windows NT 10.0.19042.0 (x64 en-US) CLR Version: 4.8 or later [Release Number = 528372] Peak Virtual Memory: 54.5 GB Private Memory: 860 MB Peak Working Set: 1.1 GB IE Version: 11.789.19041.0 User ID: 8c6c8de9-e1fe-4e86-9f12-b55fb64e4e04 Workbook Package Info: 1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True. Telemetry Enabled: True Model Default Mode: Import Model Version: PowerBI_V3 Cloud: GlobalCloud DPI Scale: 100% Supported Services: Power BISemantic model with manually entered data is breaking when getting refreshables in C# package
I created a semantic model using the 'Paste or manually enter data' option, and used this model to create a report. In my application, using the Microsoft.PowerBI.Api 5.1.0 Nuget package, calls to PowerBIClient..Admin.GetRefreshablesAsync(top: 1000, expand: "group") is throwing an exception, "Unknown RefreshType value. (Parameter 'value') Actual value was WebModeling.". Deleting that semantic model from my workspace resolved the issue, and other semantic models created from sources other than that 'Paste or manually enter data' option do not cause the issue. The relevant object from the https://api.powerbi.com/v1.0/myorg/admin/capacities/refreshables?$expand=group&$top=1000 call response is { "value": [ { "id": "...", "name": "Test", "kind": "Dataset", "startTime": "2026-05-11T23:30:24.777Z", "endTime": "2026-05-11T23:30:29.737Z", "refreshCount": 1, "refreshFailures": 0, "averageDuration": 4.96, "medianDuration": 4.96, "refreshesPerDay": 1, "lastRefresh": { "id": ..., "refreshType": "WebModeling", "startTime": "2026-05-11T23:30:24.777Z", "endTime": "2026-05-11T23:30:29.737Z", "serviceExceptionJson": null, "status": "Completed", "requestId": "...", "extendedStatus": null, "refreshAttempts": [] }, "refreshSchedule": { "days": [], "times": [], "enabled": false, "localTimeZoneId": "UTC", "notifyOption": "MailOnFailure" }, "configuredBy": [ "..." ], "group": { "id": "...", "name": "..." } } ] } The RefreshType enum, and the related RefreshTypeExtensions serializer, in the Nuget package need to be updated to handle the WebModeling refreshType.
History for report pages within usage metrics
It appears that the usage metrics data model is not storing the complete SectionId/SectionName history. Within the "Report Page Views" there are historic SectionIds that do not exist in "Report pages". Because the join is through SectionId to get the ReportName from "Reports" it makes this data model fundamentally broken.
