Disabled Include in Report refresh but still not working in Service

[msft-cap]

Hello

Appreciate any inputs. I have a PBI report that is taking long time to load. I made some changes and published to Service. To test the option, I disabled 'Include in Report Refresh' on all the tables except one small table. After publishing to Service and Triggered refresh, it still timed out. I tried disabled load as well as disabled include in report refresh as well. 

Note: I made these changes in the Desktop, and closed it without applying changes. Then published it to Service. 

[Deku · Accepted solution]

You need to apply changes otherwise the changes in powerquery are staged but not committed to the semantic model 

[v-csrikanth]

Hi @msft-cap 

We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @msft-cap 
I wanted to follow up since I haven't heard from you in a while. Have you had a chance to try the suggested solutions?
If your issue is resolved, please consider marking the post as solved. However, if you're still facing challenges, feel free to share the details, and we'll be happy to assist you further.
Looking forward to your response!

Best Regards,

Community Support Team _ C Srikanth.

[v-csrikanth]

Hi @msft-cap 
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

Best Regards,

Community Support Team _ C Srikanth.

[v-csrikanth · Accepted solution]

Hi @msft-cap 

Unfortunately, no, Power BI requires to apply changes (via Close & Apply) before publishing. This is because:

• "Close & Apply" commits the query edits to the model.
• Without it, Power BI Desktop doesn’t update the semantic model, and the Service won’t recognize any of your Power Query changes.
• Even if you modify the Advanced Editor, the data model itself isn't updated until applied.
  
  

If the above information helps you, please give us a Kudos and marked the Accept as a solution.

Best Regards,

Community Support Team _ C Srikanth.

[msft-cap]

@Deku thank you. Is there a way to publish the report to Service without relaoding the entire data on desktop after making changes in the advanced editor?

[Deku · Accepted solution]

You need to apply changes otherwise the changes in powerquery are staged but not committed to the semantic model