Forum Discussion
Business Users Refresh PBIX
I have searched the forum for this question already but did not find anything directly related.
We have successfully created a gateway into our on-premise server. I have been adding the datasets into the Power BI Service Cloud for the Business Users. When they download the PBIX file and do a refresh on the data, it would tell them that they don't have access.
Any thoughts on how to get around on this? Should I give their AD account access to the database as READ to VIEWS (Not Tables)?
5 Replies
- ribisht17
Super User
Please check this blog Allow End Users To Refresh Dataset Whenever They Want (On Demand) (c-sharpcorner.com)
Regards,
Ritesh
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau UsersBTW... Right now, my dataset is connected to the SQL Server by a SQL Authentication account. If I do any of the two methods from your link, I will not have to give the end users direct access to SQL Server right?
Thanks. The second one from your provided link may work. Let me try it out and will update this thread.
- ribisht17
Yes,
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users Ribish, the link that you have provided shows how to refresh at MS Power BI Service. If the user downloaded the PBIX file and do a data refresh, it does not work unless I give the user Read access at the database. I have tried what was in your provided link by setting at Basic Authentication with User Name and Password with Organizational. Let me know if I am doing something incorrectly. Thanks
