I assume that that you just want to hide the columns to beutify the visual, and you dont have to hide then for security?
Consider this method :-
Method 1 - Create 2 pages or 2 visuals tiles.
Then use the first tile for visual presentation without the extra columns,
and the second tile with the extra columns for excel download.
Note that you can shrink the second visual to a tiny size because you dont need to visual read columns, just allow them to be downloaded.
Method 2 - connect direct to dataset from excel.
Either give the user access to the dataset or datamart.
They can then connect Excel.
Learn how here https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-power-bi-datasets-excel
We are unpaid volunteers and you have got free expert help which took a lot of effort.
This solution works and does exactly what you asked.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos.
If you need to change or extend your request then please raise a new ticket.
One question per ticket please !
You will get a quicker response and each volunteer solver will get the kudos they deserve.
If you quote @speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.
However I decline to help impolite lazy members twice who ask misleading or incomplete questions and then dont accept the correct soltion.
Please now click the [accept as solution] and the thumbs up button. Thank you.
