Forum Discussion
PowerBI refresh fail - Expression Error.
I think the same is happening to me -
.
Anyone know if this is one and the same issue that is causing the "Users may experience processing errors when refreshing datasets in the Power BI service. We are working to resolve this issue as quickly as possible." status message we're being shown... or if I should be hunting for an issue with my dataset specifically?
Refreshes fine in Desktop, so I'm a little lost....
In my case, as per my edit, it was (or so I thought) related to the fact that I had multiple queries pointing to the same table in my data source. Combining those queries into a single query resolved my issue.
I was having a think about it and also wonder if the issue could be related to a naming convention with the queries.
In my case, originally, the multiple queries that pointed to the same table were all named very similarly. i.e. they all started with the word "Optionset". I wonder if anyone else here, even if you are not pointing more than 1 query to the same table, is naming more than a single query with a matching word?
Just a thought.