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

Power Query in Power BI services Refresh

I currently have a Power Query that pulls Web API data using Basic Authentication from our online store that works in both Excel and Power BI desktop.  So far, the only way I can find to update the data in Power BI services is to manually update the data set in either the Excel worksheet or Power BI Desktop, then the data will update in Power BI services.  Is there a way to setup Power BI services so that it will refresh the data from the query without having to go into these files and update it first?

1 ACCEPTED SOLUTION

Accepted Solutions
walterosLP Frequent Visitor
Frequent Visitor

Re: Power Query in Power BI services Refresh

I have the same request and when I spoke to Microsoft back in June, they confirmed that Power Query will be supported at PowerBI Services by end of the year 2017, so still waiting for this update as many others and hopefully, it is coming soon!

2 REPLIES 2
Moderator v-sihou-msft
Moderator

Re: Power Query in Power BI services Refresh

@SPeabody

 

Unfortunately, it's not supported to store the credential within Web.Contents() in Power Query. See a similar thread below: 

 

https://community.powerbi.com/t5/Service/Anonymous-access/td-p/19136

 

Regards,

walterosLP Frequent Visitor
Frequent Visitor

Re: Power Query in Power BI services Refresh

I have the same request and when I spoke to Microsoft back in June, they confirmed that Power Query will be supported at PowerBI Services by end of the year 2017, so still waiting for this update as many others and hopefully, it is coming soon!

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 287 members 3,479 guests
Please welcome our newest community members: