Report refresh

[Mumin192]

Hello,

I have a client that I built a report for him

When I publish the report in my account, it refreshes normally within 5 mins

When he publish the rport in his accout, it takes ages, then it gives the error below

Data sources are: BigQuery, Google Sheets and one public website source

Datakildefeil:We cannot apply operator * to types Text and Number.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.Klynge-URI:WABI-NORWAY-EAST-PRIMARY-redirect.analysis.windows.netAktivitets-ID:38ce562d-feac-46be-86ff-4ed6de132300Forespørsels-ID:5e7a344c-8457-1ed8-016d-e046a50121c2Klokkeslett:2022-11-03 14:58:46Z

Any help!

Thanks

[v-yetao1-msft]

Hi @Mumin192 

When you share your report to other users , can they refresh the report in Desktop ? Did they have the permissions to access the data source ? 

Best Regards,
Community Support Team _ Ailsa Tao

[vaibhavkale570]

it appears you have a problem in your M query code. you should check the m Query steps.

[Mumin192]

But it's refreshing from my side

And I checked all power query tables and they are working fine

And it was able to refresh from the desktop version from his side

Any other thoughts?

[vaibhavkale570]

can't take a guess with the information provided here.