Forum Discussion

JuggernautProf's avatar
2 years ago

Getting a token error on PowerBI Embedded Report that is using SSAS on-premise data source with RLS

Hi Folks,

I've been searching for weeks for an answer to this. Unfortunately my search hasn't yielded much.

I made some changes to an existing SSAS tabular model. The changes were not major. I imported a couple of new tables that are independent from the rest of the semantic model. And I added a relationship and a new table to the model. But didn't make any further changes. 

For some reason, when deploying the new SSAS model to PROD to replace the existing as the data source of our Embedded PowerBI report, we keep seeing a token error .

No changes to the RLS (Row-Level Security), no structural changes to existing relationships or tables. All we did was, introduced a new table and a new (one-to-many) relationship to that table. 

What else could be causing this access issue?

7 Replies

  • In addition to the above, the implementation of our Embedded PowerBI report is using the Service Principal method.

    • AmosHersch's avatar
      AmosHersch
      Microsoft Employee

      Hi JuggernautProf ,

      Can you please share more information about the "token error" ? Do you get an error when trying to generate the embed token for your report, or are you getting the error when using the token to view the report?

      Did you look at network traces (through browser/fiddler) to see which error is returned?

      • JuggernautProf's avatar
        JuggernautProf
        Helper I

        Yes the token error comes up when viewing the report (please see attached).