Forum Discussion

kjohansen's avatar
kjohansen
Frequent Visitor
8 years ago
Solved

data refresh disabled - windows credentials not needed (?)

I received a notification that my data refresh had been disabled.  When I investigate it says to 'edit credentials'.  I can see that it seems to have been changed to 'Anonymous'.  When I change it to...
  • Anonymous's avatar
    Anonymous
    8 years ago

    kjohansen,

    You connect to on-premises SharePoint site Excel in Power BI Desktop and use Windows authentication in Power BI Desktop, right?
    Also you import SQL data to this single PBIX file. If so, do you add all the data sources(SharePoint) and SQL Server within gateway?

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

kjohansen,

Do you connect to Excel file in SharePoint Online or On-premises SharePoint? And what is the other data sources in your PBIX file?

If you connect to Excel file in SharePoint Online in Power BI Desktop, you would need to  use "Microsoft Account" authentication, and in Power BI Service, you would need to use OAuth2 authentication.

Regards,
Lydia

  • kjohansen's avatar
    kjohansen
    Frequent Visitor
    8 years ago

    Hi Lydia, we connect via On-premises SharePoint Online.  The other datasource in my pbix file is SQL query to our data warehouse (gateway has been configured). Refresh was working on that before I added the SQL query.

     

    The two sources are not merged; I have different Visualizations for each.  

     

    Thanks for any help you can provide!

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      kjohansen,

      You connect to on-premises SharePoint site Excel in Power BI Desktop and use Windows authentication in Power BI Desktop, right?
      Also you import SQL data to this single PBIX file. If so, do you add all the data sources(SharePoint) and SQL Server within gateway?

      Regards,
      Lydia

      • kjohansen's avatar
        kjohansen
        Frequent Visitor
        8 years ago

        No, I had not added the Gateway for SharePoint.  Now that I have, it works.  Thank you!