Forum Discussion

JackPo's avatar
JackPo
New Member
10 years ago

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...
v-micsh-msft's avatar
v-micsh-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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's avatar
    JackPo
    New Member
    9 years ago

    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's avatar
      v-micsh-msft
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      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