Trouble Publishing to PowerBI Web Service via Gateway Connection

Question

We have established the PowerBI gateway &amp; 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:&nbsp;"An Error Occured while attempting to publish 'xyz' Publishing failed for an unknown reason. (PowerBINotAuthorizedException)"&nbsp;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?

luisrh · Answer

I don't know your use case,&nbsp; 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 -&nbsp; 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.&nbsp; &nbsp; If you are not leveraging Dataflows,&nbsp; you may want to take a look at them.&nbsp;good luck!

Forum Discussion

Related content

Data Ingestion Troubles

PowerBI Report - trouble switching to the PowerBI Data gateway connection after publishing

Publish Report

Trouble connection to Oracle

Trouble connecting to Redshift