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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
RickSchultz
Helper II
Helper II

Credentials required for public website?

Hi!  I've been using a personal gateway for several months with no real issues.  All my data sources are set to refresh each morning and, so long as I log on to the gateway in time (I sleep the computer at night), all refresh as expected.

 

Recently, however, I added a page from wikipedia for time zones:  https://en.wikipedia.org/wiki/List_of_tz_database_time_zones

Each time Power BI goes to refresh the datasources, it complains that the credentials for this website are not correct, and I have to manually "authorize" the site (basically, just click "Settings" for the datasource, select Data source credentials, and click the "Edit Credentials" hyperlink).  There are no credentials because, of course, it's just a public website.

 

Is there any way around this?

1 ACCEPTED SOLUTION

Hi @RickSchultz 


Based on your error it is the privacy settings when you are joining data from Simba Athena and the Web.


What you would need to do is to set the Privacy settings to Organizational for this to work.

 

You can update it as per documentation: Re: Credentials required for public website?





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

Proud to be a Super User!







Power BI Blog

View solution in original post

5 REPLIES 5
GilbertQ
Super User
Super User

Hi @RickSchultz 

 

I would suggest installing the Standard version of the on-premise gateway. And have this installed on a PC/Server that never goes off. That should allow it to not have to re-authenticate.

 

Here are more details on how to install: Install an on-premises data gateway | Microsoft Learn





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

Proud to be a Super User!







Power BI Blog

Thanks for responding, Gilbert.  I have tried to set up the gateway as you noted a while ago, but it tells me it is incorrectly configured (no mention on what the issue is) and I don't have the expertise to trouble shoot it.

 

In the meantime, the personal gateway has worked fine until now.  I'm now getting this error message (which is a bit like greek, unfortunately):
Underlying error code: -2147467259
Underlying error message: Information is needed in order to combine data
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"Odbc","path":"dsn=Simba Athena"},{"kind":"Web","path":"https://en.wikipedia.org/wiki/List_of_tz_database_time_zones"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: PrivacySetting
Cluster URI: WABI-CANADA-CENTRAL-redirect.analysis.windows.net
Activity ID: aff2142b-daeb-44c0-a177-90fdc1e85fd1
Request ID: 4d14a28f-757e-fae4-5aa8-bea7b8164069
Time: 2022-09-27 23:09:17Z

Hi @RickSchultz 


Based on your error it is the privacy settings when you are joining data from Simba Athena and the Web.


What you would need to do is to set the Privacy settings to Organizational for this to work.

 

You can update it as per documentation: Re: Credentials required for public website?





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

Proud to be a Super User!







Power BI Blog

Thanks so much, Gilbert: I'm able to refresh now - hopefully it will autorefresh in the morning.  One question, though - how would anyone know to use the "organizational" setting for access to a public website?  Not exactly intuitive...?

Hi @RickSchultz 

 

Yeah it is sorta tricky and I guess the only way to know is via experience.. I have seen the odd blog but everyone's situation is different.





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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors