Forum Discussion

GrahamR99's avatar
GrahamR99
Resolver I
4 years ago
Solved

Power Bi Report with Multiple sources Automatic refresh .

Hello I had a report that just downloaded data from Cloud Microsoft Dynamics Business Central.   I have added a new table to it which is connect to a on prem SQL Server database table.   When it...
Need Help
  • GrahamR99's avatar
    GrahamR99
    4 years ago

    Hello Anonymous 

    My Gateway settings match yours.

     

    My dataset I think is the problem, please see screen shot below;

     

     

    There is a red X for the Business Central connection.

     

    Regards

     

    GrahamR99

  • GrahamR99's avatar
    GrahamR99
    4 years ago

    The red X next to business central connect was the key here; I had to create a connect to business central in the gateway, once this was done the download worked.

lbendlin's avatar
lbendlin
Super User
4 years ago

Dynamics365BusinessCentral: Request failed: The remote server returned an error: (500) Internal Server Error. (The JWT token is not valid because its validity period has ended.

 

500 indicates that the error lies with the data source. Have you spoken to your D365 team?

GrahamR99's avatar
GrahamR99
Resolver I
4 years ago

Hi lbendlin 

I can connect to the data in Power BI desktop, why would it work there and not in the portal?

 

When you say D365 team do you mean Microsoft or the internal team?

 

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    Your internal IT team that manages your tenant.