Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

Save Odata Credentials?

Hi Everyone

 

I'm doing a small report with Power BI desktop and I'm using Odata from Project Online

I sent the report to a colleague to get his feedback but when he tries to refresh the data, he has to enter his own account and password

Is there a way to store my credentials in the odata connection?

The final idea would be to ask to the IT team to create a generic account which could connect to the data

 

Thank you for your help

 

Kind regards

1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

According to my test, if you share your PBIX file with other users, when they refresh the report, they will be asked to reenter the credentials. 

 

If you publish this report online in the Power BI Service, you need set credentials for dataset. Other users don't need reenter the credentials. If you want to share with guest users, please refer to Distribute Power BI content to external guest users with Azure AD B2B .

 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

If I don't share it via Power BI Services

The issue could be if someone external from the organization get this report

he would be able to open it and refresh the data, right?

Hi @Anonymous ,

 

According to my test, if you share your PBIX file with other users, when they refresh the report, they will be asked to reenter the credentials. 

 

If you publish this report online in the Power BI Service, you need set credentials for dataset. Other users don't need reenter the credentials. If you want to share with guest users, please refer to Distribute Power BI content to external guest users with Azure AD B2B .

 

 

 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

@Anonymous , Ask the IT team to create a generic id, that would be better.

 

Ideally you should share on power bi service 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.