Couldn't load the data for this visual

[JackPo]

Very simple PowerBI tool that uses gateway to access 5 excel sheets.  The sheet displays perfectly in the desktop app, but several of the charts online displays this error:

Couldn't load the data for this visual
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.
Activity ID46d43d90-4621-443a-9127-ad544f633e3e
Request IDd61bfc84-a5cb-feb5-7b62-0693ca608c6b
Correlation ID3d7f4e00-45be-b199-a246-e072652288c7
TimeSun Sep 11 2016 07:47:42 GMT+0800 (China Standard Time)
Version13.0.1605.478
Cluster URIhttps://wabi-west-us-redirect.analysis.windows.net

[v-micsh-msft]

Hi JackPo,

I agree with @ankitpatira. This error could be caused by several issues.

By the way, could you please explain a bit regarding the “Very simple Power BI tool that uses gateway to access 5 excel sheets.”?

Where are those 5 Excel Sheets stored?

In addition to the suggestion to start the troubleshooting from RLS, please also follow the steps below:

1. Verify Power BI account, and the related permission settings;
2. Check the connectivity between your gateway and the Power BI service, we may follow the article below for a start:
3. (Personal Gateway, On-Premises Data Gateway)
4. Check your refresh settings, Data gateway settings and Data source settings under Power BI service;
5. If all good, re-publish the PBIX file.

Regards

[JackPo]

turns out you guys are right and it is indeed due to a formula that had weird quirks.

Basically I wrote the code in the US, and the code ran in Hong Kong, and due to quirks with DAX, it calculated datediff as -1 from time to time.  

PowerBI really should have better time based DAX functions that are time zone agnostic.

[v-micsh-msft]

Hi JackPo,

Thanks for the update. If issue is solved, please Mark your solution to close this thread.

Regarding timezones, if you have any good idea, then please consider t osubmit it in the idea forum, to make Power BI better.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

If you need any further help regarding Power BI usage, please free free to post in this forum.

Regards

[ankitpatira]

@JackPo There could be number of reasons for this error. Several people have experienced it based on different scenarios. You need to start by looking at the special features / calculations / tricks used in your report. To give you example

If you're using RLS in your report and have used publish to web for that report you will get this error.

If you have used measures and calculation of that becomes invalid then you will see this error (the way you will handle that is by using IF else so if values of calculation becomes invalid  you handle that). 

Sometimes using multiple data sources results in this issue.

I would suggest you start by checking RLS, then if you have special measures / calculations and troubleshooting further from the information you get.