Forum Discussion
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...
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,
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
No, I had not added the Gateway for SharePoint. Now that I have, it works. Thank you!