Forum Discussion

Sean-OReilly's avatar
Sean-OReilly
Helper IV
1 year ago
Solved

Need Help - Data source error - The OData connector failed

Hi  My Power Bi dataset is not refreshing as a result of the below error: Data source errorExpression.Error: The OData connector failed with the following error: We cannot convert the value null to...
Need Help
  • Mich00's avatar
    Mich00
    1 year ago

    Hi Sean-OReilly ,

     

    The latest version of the connector no longer permits the 4th parameter to be null within the source (Source = Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null), .

     

    To fix this you will need to change the last 'null' to '[UseReadOnlyReplica = null]' within the Advanced Editor.

     

    • Open the powerbi desktop report 
    • Select Transform data 
    • Select and highlight your Business Central related query
    • Open Advanced editor
    • Replace the last 'null' with '[UseReadOnlyReplica = null]'
    • Ok 
    • Close & Apply once updated to all BC related queries

      EG:

      Before:
      Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null)

      After:
      Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = null])

       

      Hope this helps 🙂 

       

Mich00's avatar
Mich00
New Member
1 year ago

Hi Sean-OReilly ,

 

The latest version of the connector no longer permits the 4th parameter to be null within the source (Source = Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null), .

 

To fix this you will need to change the last 'null' to '[UseReadOnlyReplica = null]' within the Advanced Editor.

 

  • Open the powerbi desktop report 
  • Select Transform data 
  • Select and highlight your Business Central related query
  • Open Advanced editor
  • Replace the last 'null' with '[UseReadOnlyReplica = null]'
  • Ok 
  • Close & Apply once updated to all BC related queries

    EG:

    Before:
    Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, null)

    After:
    Dynamics365BusinessCentral.ApiContentsWithOptions(null, null, null, [UseReadOnlyReplica = null])

     

    Hope this helps 🙂 

     

MarcoBCSoft's avatar
MarcoBCSoft
New Member
1 year ago

Hi Mich00,

 

I still haven't resolved the issue as I don't have any powerBI reports saved but I was keen on building one.

When I click on Transform data and I select D365 Business Central I do not get the possibility of clicking Advanced Editor and I can only modify permissions.

 

Can you please help?

 

Thank you,

 

Marco

  • Mich00's avatar
    Mich00
    New Member
    1 year ago

    Hi MarcoBCSoft .  To access the 'Advanced Editor' you will need to have selected the source(s) required and then once you are in the 'Transform Data' editor you will have an option on the top banner (Home tab/'Query' section) for the 'Advanced Editor' settings.  Hope this helps and have fun creating reports 🙂