Relationships Break When Server Refreshes
Hello All, I'm reposting this as I did not get any feasable solutions and I'm pretty sure this topic went stale. Also, I'm using the May Desktop and Server edition of PBI. I've got this really strange issue that only rears it's head when viewing my dahsboard from the report server. A few of my tables have a dynamic X axis, where I can select how I want to view my axis from a slicer drop down. I've done this by adding an index column to my source data and creating a reference table from it. Next, I unpivoted the columns in the reference table that I want shown in my slicer drop down. I create a relationship between the two tables using the Index as the bridge and it's cross filtering in both directions (pic1). The slicer dropdown field has the ref table "attributes" and the chart axis field contains the "values" from the ref table. Boom, it works as expected in PBI Desktop. Great! Here is a pic showing what it looks like and using a page level filter to prove that the data is filtering correctly (pic 2 & 3). However, when I publish it to the server and it refreshes the relationships go haywire and I get funky data when filtered (pic 4) ie. When page level filter is for West, Visual should only show the West Divison, not all. (Just to clarify, the relationships look fine in the server after publishing until I give it a refresh.) The next thing I do is click "edit in PBI Desktop" and once it's on my desktop, what do you know, all the realtionships are fixed again and the report functions as intended without me doing anything. So why are the relationships getting skewed in the report server, but get fixed automaticaly once I pull the report into the Desktop app? I can asume something with the indexes is going off the rails during the refresh, but then why the automatic fix once pulling the report into the desktop app. Can anyone please provide me with some insight on this issue i'm having? Relationship set up: Finished Product Works in Desktop App Does not work when server refreshes
None of gateway instances within this cluster are connected.
I am getting this error and can't figure out how to fix it. We have a backup gateway that is connected to a laptop and that one is working fine. But we can't get the cluster gateway to work again. What do we do? How do we get a gateway online? None of gateway instances within this cluster are connected. Please find more details below about specific errors for each gateway instance.Hide details Activity ID: 4da1f484-3825-470d-accc-cf3126b983e0 Request ID: ca70f4cd-7b6c-ad84-8234-2a58f5186acb Cluster URI: https://wabi-us-central-a-primary-redirect.analysis.windows.net/ Status code: Time: Wed Apr 27 2022 06:57:16 GMT-0400 (Eastern Daylight Time) Service version: 13.0.18129.59 Client version: 2204.3.11090-train Motomentum Gateway 1: The gateway is either offline or could not be reached.
I just able to see the tooltip of the first graph in each report page
Hi, I'm just able to see the tooltip of the first graph on each page in my report in the web browser while all appear fine in the desktop version. First graph tooltip: All other graphs: Knowing that this issue didn't exist in the past. Can someone please help to find the issue?
