Forum Discussion

keinshah's avatar
keinshah
Helper I
1 year ago
Solved

undefinedPower BI error NULL

Hello community,   I have my data source as MS business central. When I refresh on desktop, it works fine without any errors. However, when scheduled refresh or manual refresh online, it returns th...
Need Help
  • Dejan-Pajk's avatar
    Dejan-Pajk
    1 year ago

    The latest version of the connector no longer permits the 4th parameter to be null.

    Please try the following solution:

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

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

virakones's avatar
virakones
Advocate I
1 year ago

In your powerbi desktop report > Transform data > select and highlight your Business Central related query > open Advanced editor > replace the first line as described above > Ok > Close & Apply once updated to all BC related queries

OutofSpec's avatar
OutofSpec
Frequent Visitor
1 year ago

This fixed my issue in Power BI Desktop, thank you!

 

But now when I upload it to my Power BI dashboard and run it, it bombs out still.  Any ideas?

 

  • Commisions_Sales_Line_Detail_Excel
    The OData connector failed with the following error: We cannot convert the value null to type Logical..
  • poggid's avatar
    poggid
    Regular Visitor
    1 year ago

    I'm trying to publish a PBIX from the desktop with the fix applied "[UseReadOnlyReplica = null]", however I'm getting this error...

    ServerError_CloudStorageBlobStorageServerException 

    when I force a manual refresh in the Power BI Service after the publish.  Any suggestions?

     

    • OutofSpec's avatar
      OutofSpec
      Frequent Visitor
      1 year ago

      I changed "[UseReadOnlyReplica = null]" to "[UseReadOnlyReplica = true]" and was able to get pass that error.

      • poggid's avatar
        poggid
        Regular Visitor
        1 year ago

        That worked. Thank you!

  • virakones's avatar
    virakones
    Advocate I
    1 year ago

    I could recommend reviewing that "Table: Outstanding_Sales_Order_Status_Excel." query line-by-line in the advanced editor for a similar line to edit. If not found (assuming the data source is an excel) you may need to open the sheet and explore the power query editor there. Open sheet > Data > Get Data > Launch Power Query Editor