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
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors