Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have found a problem that I can reproduce every time in Power BI Desktop. This was working fine the last time I made modifications to the report (a month or two ago), so is new to recent (at least March) releases.
The errors I recieved are:
What I have found is that this happens when there is a line feed in the Excel sheet column heading being loaded to Power BI Desktop. And that can be reproduced by saving an excel file somwhere with the following on a new sheet (using Alt+Enter in Excel to produce the line feed as in "Data Alt+Enter With Line Feed"):
A | B | |
1 | Data for validation | Data With Line Feed |
2 | 1 | 5 |
3 | 2 | 4 |
4 | 3 | 3 |
5 | 4 | 2 |
6 | 5 | 1 |
This does not happen in the Report when published to the Power BI service, only desktop.
Note I previously posted this here, but it was not followed up, so I'm reposting with a more correct title and up to date description.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.