Forum Discussion
Couldn't load the data for this visual
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...
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
Microsoft Employee
Microsoft EmployeeHi 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