Unable to load data for visual on Browser, though it works on Desktop

 I have exactly the same issue. Desktop version is fine - Service is showing the same error. Issue started today.

Getting the same error message. It may be an issue with the version 13.0.1700.761. 

Is anyone able to raise this with the Power BI team?

Yes, exactly same issue. Started yesterday for me. It was working perfectly earlier. There are many other visuals displaying fields with way more complex formulas. But here is the formula if that helps in narrowing down the issue.

CALCULATE(DISTINCTCOUNT(Customer[CustomerID]),FILTER(Customer,DATEDIFF(Customer[Date],TODAY(),DAY)<=7))

I've noticed that this error appears when I use aggregation over DAX calculated columns in DQ mode.

If I replace those DAX calculated columns with columns calculated in a database view then this issue disappears.

And I've met a similar issue in the last update when I use Grouping of Columns. It was working in October and November but now any visual with such grouped column cannot display the data – I see only a spinning wheel turning round and round. The same visual in Power BI Desktop works perfectly.

SuperBob - I have the same issue (aggregation with DAX), but the issue was resolved for one of my calculated columns by changing the SUM function to a COUNT (not sure why I had the SUM in there in the first place to be honest).

I'm unable to do this for other columns so could do with MS resolving this ASAP - has anyone raised a ticket?

SuperBob the issue as I see it is that these measures/calculated columns worked online before the latest software update. Now these measures/calculated columns do not work online. This is an issue. I shouldn't have to change a dataset after each software update.

doug_haines 

For sure I don't want you to modify your datasets.

I just wanted to give some hints to those who are desperately fighting with this issue (just like I did) and to the Power BI team to help them to find the root cause of this issue and fix it finally

elainam

Please check if your visuals meet following situation. There is a known issue in http://support.powerbi.com now.

Users with Direct Query datasets for which they have defined calculated columns and then measures using those calculated columns will experience errors for any visuals using those measures. Engineers have identified the issue and are currently working on a fix.

Best Regards,

Herbert

Thanks, Herbert. Eagerly anticipating the fix...