Forum Discussion
Issue with FP Risk Value Missing in Power BI Service Export
Hi Team,
I am facing an issue with data export in Microsoft Power BI.
When I export data from Power BI Desktop, the FP Risk value is visible and correctly populated. However, after publishing the report to Power BI Service, when I try to export the data from there, the FP Risk value is missing in the exported report.
This is creating a discrepancy between Desktop and Service outputs.
Could you please help me understand:
- Why the FP Risk value is not appearing in Power BI Service export?
- If there are any limitations, filters, or settings affecting this?
- The steps required to fix this issue?
Looking forward to your guidance.
Hi Shivam7355,
Please verify the export configuration settings for the report, as these control how data is exported from Power BI Service.
Power BI report designers and administrators can control the export options available for reports in Power BI Service. As highlighted in the attached image, under Report settings -> Export data, enable the report is currently configured to allow exporting summarized data.
You can also update this setting in the Power BI service. If export settings are restricted at either level, it can result in values being visible in the visual but not appearing in the exported file in Power BI Service.
For reference, please review the Microsoft documentation below:
Export data from a Power BI visualization – Microsoft LearnI hope this information helps. Please do let us know if you have any further queries.
Regards.
16 Replies
Can you provide more details. Is FP risk a column, measure, row in a table. Could really do with a data model diagram and more implementation details. How are you exporting? Could really do with a data model diagram and more implementation details.
- # of Red Flag FPs =CALCULATE (DISTINCTCOUNT(hubspot_district_performance[program_id]),FILTER (hubspot_district_performance,[Red flag-PQR-V] = "Red"|| hubspot_district_performance[Red Flag-Active site score] = "Red")) This is my measure
When you export do you see that column but with no data? Or is the column absent?
Yes, correct, I see the column name, but can't see the data. I attached the screenshot
Thank you
Are you exporting using "Summarized data"?
As a side note you are better to iteriate columns rather than the whole table
# of Red Flag FPs =
CALCULATE (
DISTINCTCOUNT(hubspot_district_performance[program_id]),
FILTER (
ALL (
hubspot_district_performance[Red flag-PQR-V],
hubspot_district_performance[Red Flag-Active site score]
),
hubspot_district_performance[Red flag-PQR-V] = "Red"
|| hubspot_district_performance[Red Flag-Active site score] = "Red"
)
)
I am exporting the data with current layout.
Sorry not sure.
Hi Shivam7355,
Could you please confirm what type of visual you are exporting the data from (table, matrix, or any other visual)? This will help us better understand the behavior.
Also, please check whether the FP Risk values are showing correctly in the Power BI Service visual before exporting, as this will help identify if the issue is with the visual itself or only during export. It would also be helpful to try exporting using both “Summarized data” and “Current layout” options to see if the behavior is the same in both cases.
Hello,
I am exporting the data table visual, and the FP Risk values are showing correctly in the Power BI Service visual before exporting. However, when I select Export data → Data with current layout, the FP Risk values are not appearing in the exported file.
Could you please help me understand why this is happening and how to fix it?
Thank you!
Hi Shivam7355,
Please verify the export configuration settings for the report, as these control how data is exported from Power BI Service.
Power BI report designers and administrators can control the export options available for reports in Power BI Service. As highlighted in the attached image, under Report settings -> Export data, enable the report is currently configured to allow exporting summarized data.
You can also update this setting in the Power BI service. If export settings are restricted at either level, it can result in values being visible in the visual but not appearing in the exported file in Power BI Service.
For reference, please review the Microsoft documentation below:
Export data from a Power BI visualization – Microsoft LearnI hope this information helps. Please do let us know if you have any further queries.
Regards.
Hi Shivam7355,
I am following up to see if you had a chance to review my previous response and provide the requested information. This will enable us to assist you further.
Thank youHi Shivam7355,
Just checking in to see if your issue has been resolved. Please let us know if you need any further assistance.
Thank you.
Hello,
I checked again, but the issue is still not resolved. I am still unable to get the FP Risk values in the exported file from Power BI Service.
Please let me know if there are any other settings or troubleshooting steps I should try.
Thank you.
Hello Shivam7355,
Since the issue is still occurring after trying the suggested steps, We recommend raising a Microsoft Support ticket for further deeper investigation.Please share all the troubleshooting steps already performed, along with the observation that the FP Risk values are visible in the Power BI Service visual but missing only during export. This will help the support team analyze the issue further.
You can create a support ticket using the link below:
Create a Fabric and Power BI Support Ticket - Microsoft Learn
Thanks and Regards.
Hi Shivam7355,
Could you please confirm if the issue has been resolved after raising a support ticket? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.Thank you for your understanding and assistance.
