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

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!