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 tayloramy answering your questions:
1) I can do a full refresh on Desktop without any errors
2)The Table 'Market Place Price Input' source is an excel file in Share point and 'New Part Check' is a text calculated column that gives no errors in desktop
3)Have no gateway configured or active it's through Cloud connections and all credentials are ok
Very strange and never happened to me
Hi Orlando_Tuga,
That helps a lot. Where is the excel file located?
Can you send a screenshot of what the advanced editor of the query for the excel file looks like in desktop?
Thanks,
Taylor.
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,
Okay, everything there looks good, that is properly pointing to the web address and not doing anything with local files and onedrive.
Can you share a screenshot of the data sources page in the semantic properties in the power bi service? We can verify what the connection looks like there.
Another thought, are there any rows in that sheet that are blank?
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, please mark this as the solution.
No blank rows in the table
The Calculated Column type Text