Forum Discussion
Refresh issues in Power BI Service
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.
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
Hi Orlando_Tuga,
This is saying that one of the M queries had an error, resulting in no data for that column, which is then referenced later on.
Are you able to do a full refresh in desktop, not just the preview?
If so, can you identify what query this column is coming from: <oii>Market Place Price Input</oii>'[<oii>New_Part_Check</oii>]
and let us know what the data source is?
Last question, are you using an on prem data gateway for this, and are the connections set up properly in there if so?
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution.