Forum Discussion
subscription error
For whever is interested,
the issue was solved after noticing that underneath a text box there was another visual for a button that was completely covered. Even though that visual had no action associated to it, was part of no bookmark or affected the report in any way, Power BI Destop decided to complain about it.
The annoying fact is that for some reason it cannot issue a correct error message and pushes some generic field name that does not make any sense.
I believe that the button visual was part of some generic template and I neglected to delete EVERYTHING that I did not end up using.
Thanks,
vrv
After trying all the suggestions I could find in the forum I'm still getting this error.
There was an error with your subscription "Merchandizing" but we still delivered itYou are receiving this email because there was an error with a subscription to Power BI Report "Sample Merchandising Promise Date Changes" created by you.
EmailSubscriptionScreenshotVisualErrorVisual errors were encountered while rendering the artifact. This subscription was delivered to recipients, however one or more visuals may be missing.Fields that need to be fixed : Something's wrong with one or more fields: (Work Orders) COMMENT_DATE, (Work Orders) COMMENT, (Work Orders) USER_NAME, (Work Orders) COMMENT
You can check the latest state of the report by clicking in the button below.
The fields in question (Work Orders) COMMENT_DATE, (Work Orders) COMMENT, (Work Orders) USER_NAME, (Work Orders) COMMENT, in the very early stages of the build were all put in one SQL for a massive 'Work Orders' Table. I wasn't able to use things this way, so I went back to SQL, and split up the tables, creating one 'Work Orders' table, and one 'Comments' table. I didn't over write the Work Orders table, but deleted it from the model, and then re imported giving the new table the same name 'Work Orders' and an all new "Comments" table. I did have one visual that used the (Work Orders) COMMENT_DATE, (Work Orders) COMMENT, (Work Orders) USER_NAME, (Work Orders) COMMENT fields, but I deleted it, and started over. I completed and published my report yesterday, and this message started immediately after creating subscriptions to the report.
I have:
checked that there are no hidden visuals.
checked that there are no measures that included those field names. (actually have no measures at all.)
checked that any splits/merges/new columns didn't include those field names
Deleted the Data Set from the environment, and re published.
I'm still getting the same error message.
Any Idea's?