cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

MDXQueryGenerator error when connecting to Power BI dataset in Power BI report builder

Hi Community,

I recenly encountered this error within the last several days when connecting to a Power BI dataset using Power BI report builder, I have the lastest version of Power BI report builder (Sep 2020). 

 

TITLE: Power BI Report Builder
------------------------------

Query preparation failed.

------------------------------
ADDITIONAL INFORMATION:

Object reference not set to an instance of an object. (MDXQueryGenerator)

------------------------------
BUTTONS:

OK
------------------------------

 

However, if I took out the RSCustomDaxFilter function in my DAX query below, it works fine. Does anyone have any suggestions on how to fix this error?

 

EVALUATE
SUMMARIZECOLUMNS (
    'Dimension Date'[Date],
    'PMC List'[PMC Name],
    'Property List'[Property Name],
    RSCustomDaxFilter(@DimensionDateDate,EqualToCondition,[Date].[Date],String),
    RSCustomDaxFilter(@PMCListPMCName,EqualToCondition,[PMC List].[PMC Name],String),
    RSCustomDaxFilter(@PropertyName,EqualToCondition,[Property List].[Property Name],String),
    "Contracted Amount", SUM('Monthly Line Item'[Contracted Amount]),
    "CountLeads", SUM ( 'Leads Summary'[CountLeads]),
    "Billed Revenue", [Billed Revenue],
    "Properties", [Properties],
    "CPL", [CPL],
    "Penetration Rate", [Penetration Rate],
    "LPP", [LPP],
    "Total Properties", [Total Properties],
    "Properties Listing", [Properties Listing],
    "ARPP", [ARPP])

 

 

5 REPLIES 5
Highlighted
Super User III
Super User III

What happens if you update it to use the code below instead of the generator?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted

@GilbertQ,

The code I used was modified from the codes generated by Report Builder. It worked fine until several days ago when the error started to happen.

Highlighted

Hi there

ANd if you run the code on the source does it work?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted

If you would like to try out a pre-release build that may have a fix, I put it here. https://microsoft-my.sharepoint.com/:u:/p/bradsy/EQh132NkvCdFgIVchpz4iGgB-ZKBuAgpN3SfuaX7DVkBdQ

 

If that does not fix it, if you can provide a generic repro, we can take a look at it.

Highlighted
Community Support
Community Support

Hi @NickNguyen,

Did you apply any change to your system environment or Datasource/connector driver?
If this issue appears without nothing changes on your device, I'd like to suggest you contact to power bi team with your pbix file for further support.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors