Forum Discussion
Connecting and refreshing Excel workbook data
Hello, As part of our effort to build dashboards in Power BI, our first step is providing Excel Workbooks with simple pivot tables for the initial data analysis. Currenly I can't see a way to pro...
Thank you for the reply.
Yes! This is my use case, so the issue may be that I am not first using a "connection only" query. I am using a query to pull directly into the data model. When another user gets the workbook, they get prompted for the credentials of the DB. They can't juse refresh the data.
If I am understanding you correctly, by using a connection only query first, that should store the DB credentials so anyone who gets the workbook can refersh the data?
Just to clarify other reading this later. There does not appear to be any way to store credentials in a query. Each user will have to reauthenticate to the data source for the queries to start working again.