Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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!
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,
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.