Forum Discussion

lmoranian's avatar
lmoranian
Regular Visitor
4 years ago

PowerBI Report Server Report Refresh

Hi,   Is there a way for reports on the web page associated with SSRSPBI to refresh the data?  I have reports using direct query and import and have scheduled refresh on the web page.  The refresh ...
SSRS. Power BI
lmoranian's avatar
lmoranian
Regular Visitor
4 years ago

We have a couple of scheduled refreshes set up and the credentials are there, but the report is not refreshing.  We have two versions on the report server, one using import and one using direct query.

rgiltner's avatar
rgiltner
Frequent Visitor
4 years ago

Is the DirectQuery report not displaying the updated data ?  The way I understand it, DirectQuery data sets pull in the latest data every time you open the report, no refresh needed.

For the report using Import, what type of credentials have you supplied for running the refresh ?  A SQL account, or a Windows Account ?  And if a Windows Account, I'm not 100% certain but I imagine the service account running the Power BI service must be able to delegate to the account trying to perform the data refresh.  If they are one in the same, totally clueless.  

If you check logs on your target SQL server, do you see anything about failed logins etc. ?