Forum Discussion

Chrily's avatar
Chrily
Regular Visitor
7 years ago

Incremental Refresh failed on PBI Service

Hi,   I recently tried Power BI Incremental Refresh. I am refreshing successfully on my local PBI Desktop, but failed when I refresh from Power BI Service.   I am getting the following error:   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

ok, I think I've fixed this at least for my report.

I our report, we had the two parameters: RangeStart/RangeEnd flagged as "Enable Load".

I wanted to display the values of these two parameters in the report itself so I can see how the values change doring the series of report refreshes.

Unfortunately, it seems like setting the "Enable Load" for these two parameters caused the error "Token Semicolon expected.".

When I unchecked the "Enable Load" flag for these parameters an published the report, the error disappeared and the report dataset got refreshed successfully.

thx, 

z.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I had the same issue, and after turning off the "Enable Load" setting on both parameters resolved the issue.

 

Thanks for posting your fix!

 

Hitesh

  • MatheusGS's avatar
    MatheusGS
    New Member
    3 years ago

    I have the same error, and I don't use incremental update. The error started after I changed the data source from spreadsheet in excel to folder.

    Message:

    Data source error: Token ',' expected. Start position: (48, 28). End position (48, 38).. The exception was raised by the IDbConnection interface. Table: Measurements.
    Cluster URI: WABI-NORTH-EUROPE-C-PRIMARY-redirect.analysis.windows.net
    Activity ID: a5eb809f-7c17-4302-8010-25eac45ed4b0
    Request ID: a8c6b435-e0e3-ac1f-5ca5-9568680109ed
    Time: 2023-03-24 16:02:45Z