Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II
Helper II

published dataset gateway

Hi all, I've had issues with this for a bit and thought I'd see if anyone had a solution or could point me in the right direction. On some of my reports, I am blending data from a published dataset on service with a on prem server. If I refresh the report in desktop - no problem. If I publish and refresh with a gateway for the "blended" report - no problem. EXCEPT when the published dataset the "blended" report is using also experiences a update. At that point, service is asking me to add the published dataset in the "blended" report to my gateway. 


It prompts me to create a connection for analysis services where the server = webaddress of the published dataset. It asks for windows credential, which I'm a bit confused on as its tied to my microsoft account, but okay I go ahead and enter my windows address (including domain) where it prompts for a map user name connection string to EffectiveUserName. I'm not even sure where to start or what to research to get the correct information to set this up.


Thus far I have been DELETING the blended report from service and REPUBLISHING to avoid having to do this, but its becoming quite cumbersome and preventing my team from using published datasets as a data source. Any ideas??

Super User
Super User



When you create a blended dataset is actually called a Composite model. Now when you connect to your On-Premise it uses accounts in the form of "Domain\UserName", but in the Power BI Service it uses "".


So to get this to work you need to create a mapping from the "" to "Domain\UserName"

Here is video explaining this more User Principal Name (UPN) Mapping in Power BI - Guy in a Cube



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog

Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.