Can't export full .pbix + can't publish after live connection workaround
Can't export full .pbix + can't publish after live connection workaround Hi community, I've been running into a frustrating chain of issues over the past few days and wanted to see if anyone else is experiencing the same. Issue 1: Can no longer export .pbix with data I have reports that I've successfully downloaded as .pbix (full copy with data) many times before. Suddenly, I'm getting the error: "We couldn't export to .pbix format." The only download mode that works now is "A copy of the report with a live connection to the data online" — the full data export fails every time. For context: - The report was originally published from Power BI Desktop (not created in the Service) - Large dataset storage format is OFF - No incremental refresh configured - The tables are not large at all, so dataset size shouldn't be a factor - No deployment pipeline involved Issue 2: Can't publish after editing the live connection .pbix After making report edits in Desktop using the live connection file, I tried to publish back to the service and got this error: "An error occurred while attempting to publish 'Report Name.pbix': The remote server returned an error: (404) Not Found." My questions 1. Is anyone else suddenly unable to export full .pbix files from reports they previously could download without issues? 2. Is there a known issue with the UK South region affecting exports and publishing? 3. Any workaround to publish a live connection .pbix back to the service? Thanks in advance, any help or confirmation that others are seeing this would be really useful!
Measure in Live Connection - Incorrect Total
Hello, I know there have been many solutions on incorrect totals from measures in Live Connection, but I can't seem to figure out the solution for my measure: No of Sessions = VAR _encounters = CALCULATE ( [Amount], FILTER ( ALL ( 'Profitability Account' ), 'Profitability Account'[Description] = "Encounters" ) ) VAR _NoOfDays = Calculate(DISTINCTCOUNT('Time'[CalendarDate]),Filter ('Time', 'Time'[DayOfWeekdayDescription] <> "Sunday" && 'Time'[DayOfWeekdayDescription] <> "Saturday" )) VAR _NoOfSession = _NoOfDays * SWITCH ( TRUE (), _encounters <= 2, 0, _encounters >= 2 && _encounters <= 10, 1, _encounters > 10, 2 ) RETURN _NoOfSession This gives me the following result (I have covered up the practice locations): You can see the No of Sessions total is incorrect. I even attempted something different by trying something different. I wanted to try something like DISTINCTCOUNTX (but this does not exist in DAX) - so I found the below solution: No of Sessions New = VAR _NoOfDays = COUNTROWS( DISTINCT( SELECTCOLUMNS( 'Time', "CalendarDate",'Time'[DayOfWeekdayDescription] <> "Sunday" && 'Time'[DayOfWeekdayDescription] <> "Saturday" ))) VAR _NoOfSession = _NoOfDays * IF ( [Encounters] <= 2, 0, IF([Encounters] >= 2 && [Encounters] <= 10, 1, 2 )) RETURN _NoOfSession I replaced the VAR _encounters with a measure instead [encounters] . And I replaced the SWITCH statement for an IF statement instead to see if that will do anything different, but it still doesn't work: The following is the Encounters measure (it's exactly the same as in the original No of Sessions DAX: Encounters = CALCULATE ( [Amount], FILTER ( ALL ( 'Profitability Account' ), 'Profitability Account'[Description] = "Encounters" )) Please help me write a new DAX measure that will fix this issue and give me correct Totals 🙂
