Forum Discussion
Power BI refresh history
HI
Im trying to get the refresh history of all my dataset and currently am following this documentation.
was able to get the url string but when i try to go to power query with excel or PBI under
GET >DATA >WEB
it says that the acccess to it is forbidden. Im the admin(owner) of the data set that im trying to pull so im not sure where im getting it wrong here.
2 Replies
Hi Anonymous ,
Have you tried to included a Authentication Access Token in the header? Please refer to this thread about usisg this api to get history of failure refresh: https://community.powerbi.com/t5/Service/PowerBI-Service-List-of-Power-BI-Reports-Data-set-s-with-Failed/td-p/852295/page/2 (Message 11 of 14)
Please also refer to following documents about how to get a Access Token of Power BI:
https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data-get-token
You can also copy the Bearer XXXX in the "Try it" of API document and try it to connect api in desktop, it is the access token and will expire in 1 hour.
Best regards,Hi Anonymous ,
How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?
Best regards,
