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.
This error could be and easy one to solve but... I didn't use excel spreadsheet in the query.
Here is the situation, it works fine until the very last step. No clue how the ... this error could appear
Had the same situation in other query but then decided to use dax instead
Solved! Go to Solution.
It might be a microsoft server error, because all query work fine in Power BI desktop.
It might be a microsoft server error, because all query work fine in Power BI desktop.
Hi @2dosik
Rename "Sheet2" to "Sheet1", I think that's where the mismatch happened
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
I'll try to explain again,
I'm pulling info to dataflow from excel files in sharepoint folder. Each one has the same pattern in name, and it has same sheet name. This query works good.
Then I reffer to this query in another query.
Works all good until, for example "groupped by" step. And it gives me erro that key doesn't match any row in the table which gives no sense.
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 |
---|---|
56 | |
20 | |
19 | |
18 | |
9 |