cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mldscience Frequent Visitor
Frequent Visitor

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.

2 REPLIES 2
Super User
Super User

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

Try doing the following steps.

 

  1. Open your converted report in Power BI Desktop
  2. Then go into the portal and delete the copy off the portal
  3. 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.

mldscience Frequent Visitor
Frequent Visitor

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

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.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)