Paginated Report in Service: Could not connect to the data source.

[RBAIGI]

As of today i am experiencing the following error when i attempt to open a specific paginated report:

Could not connect to the data source.

There was an error communicating with Analysis Services. Please verify that the data source is available and your credentials are correct. Query (34, 59) The syntax for 'OO' is incorrect. (EVALUATE SELECTCOLUMNS( KEEPFILTERS( SUMMARIZECOLUMNS( 'Dim_Constituent'[CRM_ID], 'Dim_Constituent'[Language], 'Dim_Constituent'[Province], 'Dim_Constituent'[Source], FILTER(VALUES('dim_constituent'[Language]),OR("E|F" ="All",PATHCONTAINS("E|F",'dim_constituent'[Language]))), FILTER(VALUES('dim_constituent'[Province]),OR("|AA|AB|AE|AK|AL|AR|AS|Auckl|AZ|BC|CA|CO|CT|DC|DE|Devon|FL|GA|Glouc|GU|HI|IA|ID|IL|IN|KS|KY|LA|MA|MB|MD|ME|Merse|MI|MN|MO|MS|MT|NB|NC|ND|NE|NH|NJ|NL|NM|None|NS|NSW|NT|NU|NV|NY|OH|OK|ON|OR|Oxfor|PA|PE|PR|QC|QLD|RI|SC|SD|SK|SOA|South|TAS|TN|TX|UT|VA|VI|VIC|VT|WA|Warwi|WI|WV|WY|YT" ="All",PATHCONTAINS("|AA|AB|AE|AK|AL|AR|AS|Auckl|AZ|BC|CA|CO|CT|DC|DE|Devon|FL|GA|Glouc|GU|HI|IA|ID|IL|IN|KS|KY|LA|MA|MB|MD|ME|Merse|MI|MN|MO|MS|MT|NB|NC|ND|NE|NH|NJ|NL|NM|None|NS|NSW|NT|NU|NV|NY|OH|OK|ON|OR|Oxfor|PA|PE|PR|QC|QLD|RI|SC|SD|SK|SOA|South|TAS|TN|TX|UT|VA|VI|VIC|VT|WA|Warwi|WI|WV|WY|YT",'dim_constituent'[Province]))), //FILTER(VALUES('dim_constituent'[Source]),OR(@SOU ="All",PATHCONTAINS(@SOU,'dim_constituent'[Source]))), FILTER(VALUES('dim_segment'[Donor Groups]),OR("|Active Participant|Community|Development Donor|Development Prospect|Direct Marketing|Lapsed Participant|Legacy|Long Lapsed|Volunteer" ="All",PATHCONTAINS("|Active Participant|Community|Development Donor|Development Prospect|Direct Marketing|Lapsed Participant|Legacy|Long Lapsed|Volunteer",'dim_segment'[Donor Groups]))), FILTER(VALUES('dim_segment'[Portfolio]),OR("|Active Monthly|Active Participant|Big Bike|CE General|CE Other|CE Tribute|Development Donor|Development Prospect|DM Annual|IG Pilot Control|IG Pilot Test|Intermediate|Jump|Lapsed Participant|Legacy|Long Lapsed|MOF|P2P|Ride|Special Events|Volunteer" ="All",PATHCONTAINS("|Active Monthly|Active Participant|Big Bike|CE General|CE Other|CE Tribute|Development Donor|Development Prospect|DM Annual|IG Pilot Control|IG Pilot Test|Intermediate|Jump|Lapsed Participant|Legacy|Long Lapsed|MOF|P2P|Ride|Special Events|Volunteer",'dim_segment'[Portfolio]))), FILTER(VALUES('dim_segment'[Loyalty]),OR("|Active|Active 2yr|Long Lapsed|Mid Lapsed|New|Re-acquired|Recently Lapsed" ="All",PATHCONTAINS("|Active|Active 2yr|Long Lapsed|Mid Lapsed|New|Re-acquired|Recently Lapsed",'dim_segment'[Loyalty]))), FILTER(VALUES('dim_segment'[IG Loyalty]),OR("|Active|Active 2yr|Lapsed Giving Level|Lapsed Inactive|New" ="All",PATHCONTAINS("|Active|Active 2yr|Lapsed Giving Level|Lapsed Inactive|New",'dim_segment'[IG Loyalty]))), FILTER(VALUES('dim_segment'[IG Tier]),OR("|Tier 1|Tier 2|Tier 3|Tier 4" ="All",PATHCONTAINS("|Tier 1|Tier 2|Tier 3|Tier 4",'dim_segment'[IG Tier]))), FILTER(VALUES('dim_segment'[Premium]),OR("|Non-Premium|Premium Available|Pure Premium" ="All",PATHCONTAINS("|Non-Premium|Premium Available|Pure Premium",'dim_segment'[Premium]))), FILTER(VALUES('dim_segment'[Monthly Recency]),OR("|0-3|13-18|19-24|25-36|4-6|7-12" ="All",PATHCONTAINS("|0-3|13-18|19-24|25-36|4-6|7-12",'dim_segment'[Monthly Recency]))), FILTER(VALUES('dim_segment'[HSF Recency]),OR("|>120|0-12|109-120|13-24|25-36|37-48|49-60|61-72|73-84|85-96|97-108" ="All",PATHCONTAINS("|>120|0-12|109-120|13-24|25-36|37-48|49-60|61-72|73-84|85-96|97-108",'dim_segment'[HSF Recency]))), FILTER(VALUES('dim_segment'[DM Recency]),OR("|0-12|13-24|25-36|37-48" ="All",PATHCONTAINS("|0-12|13-24|25-36|37-48",'dim_segment'[DM Recency]))), FILTER(VALUES('dim_segment'[CE Recency]),OR("|0-12|13-24|25-36|37-48" ="All",PATHCONTAINS("|0-12|13-24|25-36|37-48",'dim_segment'[CE Recency]))), FILTER(VALUES('dim_segment'[Onboarding Status]),OR("Do not onboard|No Status|Not onboarded|Onboarding|Onboarding Complete" ="All",PATHCONTAINS("Do not onboard|No Status|Not onboarded|Onboarding|Onboarding Complete",'dim_segment'[Onboarding Status]))), FILTER(VALUES('dim_segment'[Monthly Digital Onboarding Status]),OR("Do not onboard|No Status|Not onboarded|Onboarding|Onboarding Complete" ="All",PATHCONTAINS("Do not onboard|No Status|Not onboarded|Onboarding|Onboarding Complete",'dim_segment'[Monthly Digital Onboarding Status]))), FILTER(VALUES('dim_segment'[Monthly Offline Onboarding Status]),OR("Do not onboard|No Status|Not onboarded|Onboarding|Onboarding Complete" ="All",PATHCONTAINS("Do not onboard|No Status|Not onboarded|Onboarding|Onboarding Complete",'dim_segment'[Monthly Offline Onboarding Status]))), FILTER(VALUES('dim_legacy'[Legacy]),OR("|Expectant|Intent|Prospect|Suspect" ="All",PATHCONTAINS("|Expectant|Intent|Prospect|Suspect",'dim_legacy'[Legacy]))), FILTER(VALUES('dim_participant'[Participant Status]),OR("|Active|Lapsed" ="All",PATHCONTAINS("|Active|Lapsed",'dim_participant'[Participant Status]))), FILTER(VALUES('dim_exclusion'[DNS by Mail]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[DNS by Mail]))), FILTER(VALUES('dim_exclusion'[DNS by Email]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[DNS by Email]))), FILTER(VALUES('dim_exclusion'[DNS by Phone]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[DNS by Phone]))), FILTER(VALUES('dim_exclusion'[Do Not SMS]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Do Not SMS]))), FILTER(VALUES('dim_exclusion'[Premium Opt-in]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Premium Opt-in]))), FILTER(VALUES('dim_exclusion'[Premium Opt-out]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Premium Opt-out]))), FILTER(VALUES('dim_exclusion'[Cards Opt-out]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Cards Opt-out]))), FILTER(VALUES('dim_exclusion'[Labels Opt-out]),OR("0|1"OO ="All",PATHCONTAINS("0|1"OO,'dim_exclusion'[Labels Opt-out]))), FILTER(VALUES('dim_exclusion'[Notepad Opt-out]),OR("0|1"OO ="All",PATHCONTAINS("0|1"OO,'dim_exclusion'[Notepad Opt-out]))), FILTER(VALUES('dim_exclusion'[Spring Card Opt-out]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Spring Card Opt-out]))), FILTER(VALUES('dim_exclusion'[Fall Card Opt-out]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Fall Card Opt-out]))), FILTER(VALUES('dim_exclusion'[Medical Cards Opt-out]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Medical Cards Opt-out]))), FILTER(VALUES('dim_exclusion'[Other Premium Opt-out]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Other Premium Opt-out]))), FILTER(VALUES('dim_exclusion'[Heart Donor]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Heart Donor]))), FILTER(VALUES('dim_exclusion'[Stroke Donor]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Stroke Donor]))), FILTER(VALUES('dim_exclusion'[Only Stewardship Report]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Only Stewardship Report]))), FILTER(VALUES('dim_exclusion'[Solicit 1x per yr (Jan)]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Solicit 1x per yr (Jan)]))), FILTER(VALUES('dim_exclusion'[Solicit 1x per yr (Feb)]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Solicit 1x per yr (Feb)]))), FILTER(VALUES('dim_exclusion'[Solicit 1x per yr (Nov)]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Solicit 1x per yr (Nov)]))), FILTER(VALUES('dim_exclusion'[Solicit 2x per yr (Nov & Feb)]),OR("0|1"F ="All",PATHCONTAINS("0|1"F,'dim_exclusion'[Solicit 2x per yr (Nov & Feb)]))), FILTER(VALUES('dim_exclusion'[Opt-out Planned Giving]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Opt-out Planned Giving]))), FILTER(VALUES('dim_exclusion'[Opt-out Match Campaign]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Opt-out Match Campaign]))), FILTER(VALUES('dim_exclusion'[Opt-out Reminder Campaigns]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Opt-out Reminder Campaigns]))), FILTER(VALUES('dim_exclusion'[Opt-out Surveys]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Opt-out Surveys]))), FILTER(VALUES('dim_exclusion'[Opt-out Stewardship Report]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Opt-out Stewardship Report]))), FILTER(VALUES('dim_exclusion'[Development]),OR("0|1" ="All",PATHCONTAINS("0|1",'dim_exclusion'[Development]))), FILTER(VALUES('dim_exclusion'[Active Participant]),O

There are two copies of this paginated report in separate premium workspaces. One that is 'live' with data that refreshes daily. The other is a test copy that uses a static dataset. Both were working yesterday. Today neither is working and they both report the same error. The 'live' copy has not been modified in any way in the last month or more.

The issue points to a syntax error in the table query but I dont know where or how this 'OO' got into the query, its not in the script in report builder.

When i try to run the paginated report from within report builder it runs fine, no error.

[rbrocks]

We are also seeing a similar issue here. No changes have been made, but reports that use the paginated report visual in multiple workspaces are not loading.

[RBAIGI]

At a glance there appears to be an issue with parameters that are similarly named?

Parameters 'LPOO' and 'NPOO' are causing syntax issues

there are also parameters in this report named 'POO' and 'CPOO' dont appear to be affected.

Similarly 'SNF' is causing syntax issues.

There is a parameter named 'SN' that does not appear affected.

When i remove the affected parameters, the report is able to resolve in service.

[RBAIGI]

Confirming that renaming the parameters affected by the syntax error seems to fix the issue.

[zthill]

We are experiencing this same issue.  Reports work fine when executed locally in Report Builder but FAILS or gives wrong results when executed on PBI Service.

It's impacting many reports for us. It appears to be related to parameter names being dynamically changed by the service when used within DAX.  

Unfortunately just changing parameter names isn't resolving the issue for us.  We need this resolved asap

[rbrocks]

I was able to resolve my issue by removing the brackets from around the parameter names. Before my parameters in the DAX query were @[Year] for instance. I changed it to @Year. Now the report renders in the service. Hopefully this helps someone else.

[mvabalaitis]

From what I can tell parts of the parameter names are being stipped out by the PBI service and are appended to the DAX code causing the dataset to fail. As others mentioned this is only happening within PBI service and all reports are successful locally. 

Currently, you should not trust any reports that utilize PBI datamodels as sources. Some of our reports succeed but return partial or incorrect results as a result of this bad DAX generation.

[v-yingjl]

Base on the above comments, seems like renaming the parameters affected by the syntax error could fix this issue.

In addition, similar issue has been submited internal(ICM: 271730135), would update here as soon as possible if there is any progress about this issue.

Best Regards,
Community Support Team _ Yingjie Li

[v-yingjl]

Update:

About the ETA of this issue is 2/22 for NorthCentralUS and 2/24 for PROD clusters.

Best Regards,
Community Support Team _ Yingjie Li