Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more

Reply
Anonymous
Not applicable

Query Designer Cannot find cube

I've connected a dataset from BI service and used BI Desktop report analyzer to create my dataset.  When I try to create a  parame ter using query designer I get this message: "Cannot find cube".  An explaintion for what is going wron would be helpful.

 

 

3 REPLIES 3
StefanoGrimaldi
Resident Rockstar
Resident Rockstar

you will need to share some more details, maybe the M code, screenshoots samples, the error code you getting etc, that help for people to be able to give a more exact response 





Did I answer your question? Mark my post as a solution! / Did it help? Give some Kudos!

Proud to be a Super User!




Anonymous
Not applicable

Thanks Stefano.  Please see below

KReynolds_0-1633537803877.png

 

// DAX Query

DEFINE

  VAR __ValueFilterDM1 =

    FILTER(

      KEEPFILTERS(

        SUMMARIZECOLUMNS(

          'Sales Entry'[Item No_],

          'Prod No'[Prod No_],

          'Sales Entry'[State],

          'Sales Entry'[Variant Code],

          Sales Entry'[Location Code],

          "SumRemaining_Quantity", CALCULATE(SUM('Sales Entry'[Remaining Quantity]))

 

        )

      ),

      [SumRemaining_Quantity] > 0

    )

 

  VAR __DS0Core =

    SUMMARIZECOLUMNS(

      ROLLUPADDISSUBTOTAL(

        ROLLUPGROUP(

          'Sales Entry'[Item No_],

          'Prod No'[Prod No_],

          'Sales Entry'[State],

          'Sales Entry'[Variant Code],

          'Sales Entry'[Location Code]

        ), "IsGrandTotalRowTotal"

      ),

      __ValueFilterDM1,

      "SumRemaining_Quantity", CALCULATE(SUM('Sales Entry'[Remaining Quantity]))

 

    )

 

  VAR __DS0PrimaryWindowed =

    TOPN(

      502,

      __DS0Core,

      [IsGrandTotalRowTotal],

      0,

      'Sales Entry'[Item No_],

      1,

      'Prod No'[Prod No_],

      1,

      'Sales Entry'[State],

      1,

      'Sales Entry'[Variant Code],

      1,

      'Sales Entry'[Location Code],

      1

    )

 

EVALUATE

  __DS0PrimaryWindowed

 

ORDER BY

  'Prod No'[Prod No_]

KReynolds_1-1633537907418.png

 

KReynolds_2-1633537967609.png

 

Hi there, I am facing this same issue. Did you ever find an answer to it?

Helpful resources

Announcements
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.