Forum Discussion

danishwahab's avatar
danishwahab
Helper I
1 year ago

Issue while reusing existing table/query

Hi Everyone,   I'm facing an issue while refreshing a report which is published on the Power BI Report Server. Everything works fine while refreshing on the Desktop however fails when refreshing sa...
Need Help
collinq's avatar
collinq
Super User
1 year ago

Hey danishwahab ,

 

Thanks for the clarification, I misunderstood and thought the issue was in Desktop.  I did read the answer from Anonymous .  I agree with you though that this can get cumbersome.

 

I am wondering if you have confirmed that every single data field has a data type that is NOT "any"?

What about the Section1/LocationTypeMaster/ field specifically?

Also, do you have a merge or two where the issue might be coming from?

I am wondering if instead of redoing the whole thing if you can move the step up or down and get around the issue???

danishwahab's avatar
danishwahab
Helper I
1 year ago

The issue isn’t with datatypes. The problem arises when referring to another table as a source, which causes the scheduled refresh to fail on the server after deployment. However, the refresh works fine on the desktop.


Thanks!