Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

"Show as Table" Summarizing Incorrectly

Hello,

 

I have a Power BI report published to the web for my organization that has started showing some odd behavior.

 

I have a visual that shows the correct values (just sum simple sums of a field, and then 2 simple measures that show as a percentage). The error comes in after users hit "Show as Table", the table is not correctly returning the measures, instead of showing the values seen in the visual, it looks like it is incorrectly aggregating data and adding a series of percentages together. This issue is corrected if you use the "Export Data" option, and it also is not present when using the Desktop version of "Show as Table". This aggregation problem only occurs in the web service when using "Show as Table".

 

I've republished the report to see if that caught the issue but no luck, and again, this issue doesn't occur when I use the "Show as Table" feature in the desktop application.

 

Any ideas on what I can do to troubleshoot? Thanks!

General Comment
Need Help

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    GilbertQ 

    I tried the reset to default as my first go-to for troubleshooting and that did not resolve the issue. When I try the same feature from within the application, the expected results are returned. It is only within the published web report that the feature incorrectly summarizes data inside of Show in Table.

    • GilbertQ's avatar
      GilbertQ
      Super User
      5 years ago

      Hi Anonymous 

       

      I would give it an hour or so after updating or uploading the data to make sure that it has to time work in Publish to Web.

       

      I also do recall that as far as I know it is not possible to export the data from publish to web?

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        I may have mis-spoken, I have it published to a workspace (not embedded in web outside of the Power BI space) that is shared with internal users.

         

        Regardless following republishing the report and reset to default options, the Show as Table feature continues to return incorrectly summarized mesaures, but the Export to Data option returns accurate results.

  • GilbertQ's avatar
    GilbertQ
    Super User
    5 years ago

    Hi Anonymous 

     

    What happens when you click on the Reset to Default button when you view the report in the PBI Service?

     

    You did say you are using Publish to web, what happens when you just view the report in the App workspace, does it work then?