cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MissMintox Regular Visitor
Regular Visitor

Web Anonymous refresh failure in Power bi Service

I'm trying to access data from ApplicationInsights as an "anonymous" (using web connector in power bi desktop) and the refresh works fine in Power bi desktop. However, when I'm trying to sign in to set the refresh on service, it's giving an"Invalid credentails" error.

 

Therefore, I followed the RelativePath technique as described in this thread: Anonymous access by @DuncanP.

However, when I did it, I'm getting another error of "404: not found".

 

In the same thread, there's a workaround mentioned by @fso executing query somewhere else (eg. by using Google spreadsheet) something that I'm not familiar with.  What exactly is this and how this works in my case (where I need the scheduled refresh every 24 hours)?

 

Or is there an alternative workaround for this, Can anyone please direct me in the right path?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
MissMintox Regular Visitor
Regular Visitor

Re: Web Anonymous refresh failure in Power bi Service

Hi all,

 

Thanks for your responses.

 

I was able to solve this using a simple alternative method by changing "anonymous connection" to "basic" and passing API key as the username on both desktop and service

 

 

3 REPLIES 3
prihana Member
Member

Re: Web Anonymous refresh failure in Power bi Service

Executing query somewhere else means, instead og connecting directly to the source from PowerBI, You can call the API from Google Sheets and use that sheet as the data source.

Community Support Team
Community Support Team

Re: Web Anonymous refresh failure in Power bi Service

Hi @MissMintox,

 

I 'd like to suggest you share file with source path, then use power bi excel connector to get data from that link.

I think this way can work through your scenario.

 

Regards,
Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Highlighted
MissMintox Regular Visitor
Regular Visitor

Re: Web Anonymous refresh failure in Power bi Service

Hi all,

 

Thanks for your responses.

 

I was able to solve this using a simple alternative method by changing "anonymous connection" to "basic" and passing API key as the username on both desktop and service

 

 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

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

Top Ideas
Users Online
Currently online: 25 members 893 guests
Please welcome our newest community members: