Forum Discussion

Orlando_Tuga's avatar
Orlando_Tuga
Helper I
11 months ago
Solved

Refresh issues in Power BI Service

In Power BI Desktop i have a report that when i refresh is ok and all is good and data is fine. I published it and when i refresh the data in Power BI i get an error as following: Error fetching dat...
Need Help
  • tayloramy's avatar
    tayloramy
    11 months ago

    Hi Orlando_Tuga, 

     

    So far we confirmed that the data at source is valid, and that the crednetials are valid. There's no gateway to cause problems in the middle, and the sharepoint connection is properly referencing the web source and not a local copy of the file. 

     

    I'm not sure why PowerQuery is returning rows with errors in the service but not in desktop.  

    v-tejrama do you have any suggestions? 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution.

     

  • PBI_Consultant's avatar
    PBI_Consultant
    10 months ago

    Hi Orlando_Tuga,
    This means that the calculated column New_Part_Check in the table Market Place Price Input is failing to evaluate for at least one row when refreshed in the Power BI Service. It will work in Desktop but it will throw an error in service, both work differently. So, first you enter at least one row in the table and then try to refresh it.
    Thanks

v-tejrama's avatar
v-tejrama
Community Support
10 months ago

Hi  Orlando_Tuga ,

 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

 

Thank you.

 

v-tejrama's avatar
v-tejrama
Community Support
10 months ago

Hi  Orlando_Tuga ,

 

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

 

Thank you.