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...
Need Help
  • 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

WALEED's avatar
WALEED
Advocate II
8 years ago

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
8 years ago

WALEED,

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

Regards,
Lydia

  • WALEED's avatar
    WALEED
    Advocate II
    8 years ago

    I'm afraid I can't because the data belongs to a company. I've had partial success by adding a column (TRUE/FALSE) to mark the rows wanted in Power Query (rather than filtering them out) so that I can filter based on this column in Power BI.

    • huguest's avatar
      huguest
      Advocate II
      8 years ago

      I am having the same problem.  Any update on this?

      • WALEED's avatar
        WALEED
        Advocate II
        8 years ago

        The complexity of queries and size of data cause exponential problems in Power BI. In this case, I ended up writing my own app to transform the data.

        Sorry, I know this isn't the answer you're after.