cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
imaahm
Advisor

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

Accepted Solutions
Super User
Super User

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

@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)


Near SE WI? Join our PUG Milwaukee Brew City PUG
Highlighted
imaahm
Advisor

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

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

2 REPLIES 2
Super User
Super User

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

@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)


Near SE WI? Join our PUG Milwaukee Brew City PUG
Highlighted
imaahm
Advisor

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

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
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 376 members 4,243 guests
Please welcome our newest community members: