Forum Discussion

Haya's avatar
Haya
Icon for Helper II rankHelper II
6 years ago
Solved

Your data source can't be refreshed because the credentials are invalid.

Dears, for the first time I've created Pwoer BI report from sharepoint online list using power bi desktop, then publish it to power bi web I'v downloaded personal gateway to keep the report updated...
Need Help
  • Haya's avatar
    Haya
    6 years ago

    I found that my organization block the connection between thier Sharepoint and Power BI service for security reasons.

    so it's nothing about Power BI.

Haya's avatar
Haya
Icon for Helper II rankHelper II
6 years ago

Thanks Anonymous 

I'm using SharePoint list connector to get data from SharePoint online. So, what is the solution for enabling scheduale refresh and how can I edit the credetiontials?

Note that when I click edit credetials, these are the only options appear and it didn't work, there is no option for typing my credentials (email & Password)

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Haya ,

Based on my test, SharePoint online list supports OAuth authorities and not require the gateway to handle refresh options.

Any advanced operations in your query tables? (e.g. merge, combine, reference other connection mode data sources, invoke custom functions...) They will disable someone of authority modes.

Regards,

Xiaoxin Sheng

  • Haya's avatar
    Haya
    Icon for Helper II rankHelper II
    6 years ago

    I tried to delete the personal gateway, now the "Schedual refresh" and "Data source credentials" options become gray !

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Haya ,

      Obviously, you are working with mixed Datasource. For your scenario, it still requires a getaway to handle refresh on permission data sources.

      Data refresh in Power BI 

      Regards,

      Xiaoxin Sheng

      • Haya's avatar
        Haya
        Icon for Helper II rankHelper II
        6 years ago

        Anonymous  I'm not working with mutiple data source !

        I'm working with Sharepoint online list only (Single list) 

        I've tried again, following these steps"

        1- Get Data from Sharepoint online list in Desktop power BI

        2- Modeling & Visulize it.

        3- Publish to Power BI Service , then going to setting and this is the result