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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
imaahm
Advocate I
Advocate I

Power BI Enterprise Gateway, should it recognize Server and Database name within Parameters?

Hello everyone - 

 

When I publish my Power Bi solution it will uses my server and database name to match the data-source in enterprise gateway for connection.  If it finds the match then will connect to my data-source under the current gateway.  If I create a Power Bi solution with two Parameters (one used for Server and other for Database name) then it looks like it can’t find the data-source under gateway.  Is this correct and how can I get around it?  

 

Thank you

2 ACCEPTED SOLUTIONS
Seth_C_Bauer
Community Champion
Community Champion

@imaahm "If I create a Power Bi solution with two Parameters (one used for Server and other for Database name) then it looks like it can’t find the data-source under gateway.  Is this correct and how can I get around it?" 

Do you mean after you've selected the Server and Database in the PBIX and tried to publish?

Or are you trying to Publish without selecting the parameters? (Because this isn't currently supported in the Power BI Service yet)


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

Thank you @Seth_C_Bauer ,  after I selected the Server and Database in the PBIX

  • Manage Parameters > prmServerName > CurrentValue > MyServerName  
  • Manage Parameters > prmDatabaseName > CurrentValue > MyDBName

and then I publish.  

 

 

Update:

I recreated my solution and this time it did work.  Thanks for your response.

 

Thank you again

View solution in original post

2 REPLIES 2
Seth_C_Bauer
Community Champion
Community Champion

@imaahm "If I create a Power Bi solution with two Parameters (one used for Server and other for Database name) then it looks like it can’t find the data-source under gateway.  Is this correct and how can I get around it?" 

Do you mean after you've selected the Server and Database in the PBIX and tried to publish?

Or are you trying to Publish without selecting the parameters? (Because this isn't currently supported in the Power BI Service yet)


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

Thank you @Seth_C_Bauer ,  after I selected the Server and Database in the PBIX

  • Manage Parameters > prmServerName > CurrentValue > MyServerName  
  • Manage Parameters > prmDatabaseName > CurrentValue > MyDBName

and then I publish.  

 

 

Update:

I recreated my solution and this time it did work.  Thanks for your response.

 

Thank you again

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors