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

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

@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

@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

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors