Forum Discussion

WALEED's avatar
WALEED
Advocate II
8 years ago
Solved

Data Loading Fine in Power Query but not Loading in Power BI

I'm stuck at the "Apply query changes" dialog in Power BI after closing Power Query.

 

 

It's odd because T01 loads fine and displays all intended results in Power Query.

 

Here's the code from Advanced Editor: (Works fine in Power Query!)

 

let
    FilterSource = Table.SelectRows(CLKZ, each ([Key UID] = 287791)),
    FilterClass = Table.SelectRows(FilterSource, each ([OBJECT RELATION] = "TableTemToClass")),
    FilterColumn = Table.SelectRows(FilterSource, each ([OBJECT RELATION] = "TableTemToColumn")),
    Rows = Table.SelectRows(DATA, each List.Contains(FilterClass[OBJECT NAME],[CLASS NAME])),
    Columns = Table.SelectColumns(Rows, FilterColumn[OBJECT NAME])
in
    Columns

 

 

If I remove this line, the query manages to apply in Power BI

 

    Rows = Table.SelectRows(DATA, each List.Contains(FilterClass[OBJECT NAME],[CLASS NAME])),

I'd change Columns to this when making the change above

    Columns = Table.SelectColumns(DATA, FilterColumn[OBJECT NAME])

 

 

Some Context:

DATA = A table with roughly 200 columns and 200,000 rows.

CLKZ = A table with a set of relations that define sub-tables "T01, T02, T03, etc...)

T01 = a table extracted from DATA with certain columns and certain rows.

 

Both DATA and CLKZ are CSV files inside ZIP files in a Sharepoint folder. Both are loaded without trouble into Power Query as well as Power BI.

 

Perhaps it's a bug with a workaround? Perhaps there's a better way of doing this altogether?

  • Anonymous's avatar
    Anonymous
    8 years ago

    WALEED,

    Please uncheck the following options in your Power BI Desktop file and then check if you can apply query change.


    Regards,

    Lydia

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    WALEED,

    Please uncheck the following options in your Power BI Desktop file and then check if you can apply query change.


    Regards,

    Lydia

    • WALEED's avatar
      WALEED
      Advocate II

      Hi Anonymous,

       

      Thanks for the quick response. Gave it a go but unfortunately, I'm stuck at the same loading dialog.

      • Anonymous's avatar
        Anonymous
        Not applicable

        WALEED,

        Is there any possibility that you can share us the data source? I will test it in my Power BI Desktop.

        Regards,
        Lydia