web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Webservice link changes when syncing to Power BI and the data refresh fails because of that

(0) ShareShare
ReportReport
Posted on by 174

Dear Community,

Have you come across the issue when webservice link used in the Power BI report connected to the BC keeps changing? This causes our Power BI report to stop syncing.

I have the same question (0)
  • Nikita Che Profile Picture
    174 on at
    RE: Webservice link changes when syncing to Power BI and the data refresh fails because of that

    Duilio, good morning! Thank you for this detail, it really has helped find the reason!

  • Verified answer
    THE Italian Profile Picture
    on at
    RE: Webservice link changes when syncing to Power BI and the data refresh fails because of that

    This is reported in the following Yammer thread

    www.yammer.com/.../

    (if you do not have access, I will report this down below)

    This dates back to 15th September

    ...

    Dear Partners, just a heads-up on a known issue with the Power BI integration (failed refresh of reports). A recent bugfix in the cloud platform caused an unexpected side effect related to environment name lower/uppercase and reports created in the past using Power BI Desktop. We are working on a possible solution but to easily mitigate this a manual update is needed to re-select or re-type the environment name – either in Power BI Desktop where the report was created or directly in the Power BI website (dataset settings):

    pastedimage1600786599376v1.png

    and on 16th another update

    Update for partners/customers:

    current plan is to quickly (meaning today, next few hours) revert back so the older, untouched reports will now start refreshing. In the meantime we will improve Power BI connector so it becomes resilient to such changes. The only downside is that the reports manually updated yesterday/right now would need to be updated again later on unless they have UPPERCASE environment name (the safest way to refer to environment from now on) – so we would suggest to hold on for now.

    BTW this change has happened already so the untouched reports should be unaffected from now on...

  • Nikita Che Profile Picture
    174 on at
    RE: Webservice link changes when syncing to Power BI and the data refresh fails because of that

    For some reason that we are trying to understand, the word "Production" keeps changing from proper case to CAPITALS. 

    MicrosoftTeams_2D00_image-_2800_17_2900_.png

  • Suggested answer
    Stefano Demiliani Profile Picture
    37,166 Most Valuable Professional on at
    RE: Webservice link changes when syncing to Power BI and the data refresh fails because of that

    What do you mean with "changing"? A WS url doesn't change, it's fixed for environment. Only the company can change.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Nimsara Jayathilaka. Profile Picture

Nimsara Jayathilaka. 4,252

#2
Rishabh Kanaskar Profile Picture

Rishabh Kanaskar 4,117

#3
Sumit Singh Profile Picture

Sumit Singh 2,956

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans