Forum Discussion

brianb01's avatar
brianb01
New Member
3 years ago

Trouble Publishing to PowerBI Web Service via Gateway Connection

We have established the PowerBI gateway & necessary data flows. When a user pulls in the data to PowerBI Desktop and makes changes to the table schema (adding additional tables) and attempts to publish we recieve the following error:

 

"An Error Occured while attempting to publish 'xyz' Publishing failed for an unknown reason. (PowerBINotAuthorizedException)"

 

This user is able to publish files regularly but once tables are added we recieve this not authorized exception. Any ideas where we need to look to permission this/allow publishing to the web service?

Need Help

1 Reply

  • luisrh's avatar
    luisrh
    Icon for Responsive Resident rankResponsive Resident
    3 years ago

    I don't know your use case,  but when you are in an environment where data consistency is important it is usually best to leverage single source of truth for these datasets -  Using granular dataflows allows you to create these new 'tables' in the service and then allows you to leverage these in modeling new datasets as well as referencing these in PBI desktop.    If you are not leveraging Dataflows,  you may want to take a look at them.

     

    good luck!