Forum Discussion
Report Server Import to Direct Query Report is not updated
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.
3 Replies
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.
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.
