Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Schedule data refresh failure

Hi,   I have set a scheduled refresh on Power BI but today found an error below but when I refreshed on Power BI desktop is no error.   Data source error: Expression.Error: <pii>We cannot convert...
Need Help
  • v-janeyg-msft's avatar
    v-janeyg-msft
    4 years ago

    Hi, Anonymous 

     

    The information you provided is too little for us to judge. Please add more information.

    First, I suggest you check whether there is a binary data type in column in Power Query.

    Second, you can check whether there is a problem with data source credentials, privacy level(public) in service.

    Or you can try to delete all reports related and re-publish it to see if it has issue.

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.


    Best Regards,
    Community Support Team _ Janey

v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, Anonymous 

 

The information you provided is too little for us to judge. Please add more information.

First, I suggest you check whether there is a binary data type in column in Power Query.

Second, you can check whether there is a problem with data source credentials, privacy level(public) in service.

Or you can try to delete all reports related and re-publish it to see if it has issue.

 

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.


Best Regards,
Community Support Team _ Janey

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thank you for consideration.

 

I try to revise the query again and that solved the problem.