Inserting a line break into a regular text box is as easy as hitting the Enter key unless you're using an expression, in which case those line breaks are ignored.
If you are using an expression for a text box, concatenate with the following constant to insert a line break:
+ vbCrLf
This results in the insertion of non-printing carriage-return and linefeed characters (basically the equivalent of hitting the Enter key).
Are you working on a very simple IF statement in Power Query, have gone over your syntax a thousand times, and are still seeing the following error message?
Token Eof expected.
Power Query is actually case sensitive. It's a shame it doesn't just tell you this fact as a side note to help you troubleshoot, because all you have to do is change your uppercase IF, THEN, and ELSE to lowercase if, then, and else.
I hope this post can save even one other person the maddening amount of time I spent trying to figure out what I'd done wrong in a very simple expression.
In a Power BI report if you have sufficient permissions (as well as a Pro or Premium license) then you will be able to export the underlying data for a visualization to Excel.
First, hover your mouse in the upper right-hand corner of the visualization until you see an ellipsis appear. If you put your mouse over it you will see the tooltip 'More options' appear. Click on this ellipsis and then click on 'Export data'.
Choose whether you would like to export the summarized data or the underlying data.
Choose a file format. Be aware that each format has a maximum number of records that it will export, so this won't work for larger datasets:
Posts
