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 have a use case where my user wants to be able to export the data from a filtered BI table into Excel and then use that file as an upload file into another one of our systems.
The problem is that pesky line BI appends to the bottom of the file that lists the filters that have been applied, necessitating an extra step of opening the excel, going to the end of the file, and removing that info.
Is there any way to NOT have that line appended, and just getting only the data itself?
Thanks in advance for any help; I'm pretty much expecting a negative answer, but it can't hurt to ask.
Solved! Go to Solution.
No, you cannot configure that.
Alternatives are:
A number of ways to go about it. There are surely more.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingNo, you cannot configure that.
Alternatives are:
A number of ways to go about it. There are surely more.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThank you - your first alternative might be possible for us; I'll check into that.
#2 is out simply because we only have Pro, and since this needs to be easily accessible to a user who doesn't have the back-end access I do, we probably won't try #3.
Appreciate your time and help!
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.