topic Re: Report Server Import to Direct Query Report is not updated in Report Server

Report Server Import to Direct Query Report is not updated

Anonymous — Tue, 22 Oct 2019 18:49:03 GMT

We are seeing a bug where, on on-premise report server, a power bi report is not updated with the latest data, when it is converted from import to direct query (in power bi desktop), and uploaded to the server.

We tested with a report which only contained and started with direct query and it is working perfectly fine and is updated. But, if the report is converted from Import to Direct Query in Power BI Desktop and is, then, uploaded to Report Server, it does not query the latest data.

Since there is no way to refresh a Direct Query report, the report needs to be downloaded, refreshed in Power BI Desktop, and then reuploaded. This is not achievable on Production Report Server.

Re: Report Server Import to Direct Query Report is not updated

d_gosbell — Tue, 22 Oct 2019 23:01:31 GMT

Try doing the following steps.

Open your converted report in Power BI Desktop
Then go into the portal and delete the copy off the portal
Then go back to Power BI Desktop and save the report back to the portal

When you save a pbix report up to the portal some of the connection details get split out and I don't think this handles the situation when you convert from Import to Direct Query properly. Doing the above steps should fix this situation.

Re: Report Server Import to Direct Query Report is not updated

Anonymous — Mon, 28 Oct 2019 15:54:01 GMT

d_gosbell,

I tried the steps you laid out, but still getting the same issue.

I tried downloading the file and uploading to the same server with a different name, but the issue persists.

I even tried uploading to a different server, but still no luck.

I had to download the file, because I do not have the original file.

Thank you for your suggestions! Please let me know if you think I should try something else.

Re: Report Server Import to Direct Query Report is not updated

Anonymous — Mon, 24 Feb 2020 13:27:11 GMT

Hi All,

I'm also facing a similar issue.

Any help, much appreciated.

Regards,

Param