The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi @NISH72 ,
When you create a slicer to show blank city, click (..) button in the table visual and select ‘Export data’, it will export the filtered result to excel as a .CSV file:
The most important limitation you should notice is the maximum number of rows that Power BI Desktop and Power BI service can export from an import mode report to a .csv file is 30,000.
For further information about export data to excel, you can refer the following Microsoft document that could help you:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
AFAIK, it exports the data being used, not just what is filtered.
Have you considered using the Analyze in Excel functionality? YOu can download the addin using the Down arrow in the service in any report. The arrow is in the upper right. Download Analyze in Excel, install, then use Excel to pull the data. It will still pull all of it, but you can create filters and only show in Excel what you want.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingUser | Count |
---|---|
78 | |
73 | |
37 | |
30 | |
28 |
User | Count |
---|---|
107 | |
100 | |
55 | |
49 | |
45 |