Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
@WALEED,
Please uncheck the following options in your Power BI Desktop file and then check if you can apply query change.
Regards,
Lydia
@WALEED,
Please uncheck the following options in your Power BI Desktop file and then check if you can apply query change.
Regards,
Lydia
Hi @v-yuezhe-msft,
Thanks for the quick response. Gave it a go but unfortunately, I'm stuck at the same loading dialog.
@WALEED,
Is there any possibility that you can share us the data source? I will test it in my Power BI Desktop.
Regards,
Lydia
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.
I am having the same problem. Any update on this?
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.
Hi,
I've got the same issue here : all the lines loaded in Power Query, only half in Power BI Desktop. I unchecked the boxes as recommended, didn't do anything. I deleted and recreated the query, didn't change anything neither. Does someone have an idea ? Is there maybe some cache files for Power BI Desktop that the software is using instead of the feshest one ?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |