Can't connect - Githubissues

migueesc123 / PowerBIRESTAPI

A Microsoft Power BI Data Connector or Power Query Connector for the Power BI REST API

MIT License

232 stars 73 forks source link

Can't connect #48

Closed vsslasd closed 3 years ago

vsslasd commented 3 years ago

Great idea - this connector. It's something that is missing in PowerBI. Unfortunately, we cannot utilize it yet... is there a newer version ? We went through the steps a number of times with Microsoft and kept running into the same issue. when trying to attach to any of the database objects, we get error messages. including: "We couldn't authenticate with the credentials provided. Please try again."

We have tried this using various credentials, without avail.

Any thoughts on how to resolve ?

migueesc123 commented 3 years ago

Hey! Could you provide a set of steps to reproduce the issue?

If the application says that you couldn’t authenticate, that might be sign that there are some missing scopes to be enabled at your application, but nothing that we can control at the custom connector level.

marcmahmoodivc commented 3 years ago

Hi Miguel,

Great Custom Connector; thank you!

I am able to access details on Workspaces / reports etc. without any problems using the custom connector.

Unfortunately I too am unable to access the "Event Activity Log" due to permissions. I suspect my account would require Tenant Level Audit Log reads rather than my Power BI Service Admin permissions which (in theory) enable me to read Power BI specific Audit Log entries only...

Kind regards,

Marc PBIDesktop_ecCLpCppWx PBIDesktop_HTrIUhBjpf PBIDesktop_mD5AOrocWY

migueesc123 commented 3 years ago

Resolved outside of GitHub. Couldn't determine the root cause or repro the issue, but the current instructions of the repo worked perfectly.

marcmahmoodivc commented 3 years ago

Hi Miguel,

Thank you for your help on this; I managed to resolve it and learnt a lot along the way:

for those unable to see the Custom Connector in PBI desktop, make sure you add it to the correct folder if you have OneDrive redirection set up (for me I had to go to C:\Users\\OneDrive - \Documents\Power BI Desktop\Custom Connectors)
the API permission Tenant.Read.All (whose name scared the crap out of our Security team) has a very small grayed out button at the top titled "Grant admin consent for " which only a Tenant admin can click or see properly. As a Power BI Service Admin, I did not realise this!

It's all working now and is a great time saver and simplifier of the whole process.

Thanks again,

Marc

peterkalk commented 3 years ago

I've had the same problem after following the installation instructions: No access to the admin API's. Error message: "We couldn't authenticate with the credentials provided". After trying a lot of possible solutions I did the following and this solved the problem (I only had Application permission for Tenant.Read.All and no delegated permission):

Go to Azure Active Directory -> App registrations and choose your Power BI API App.
Go to the Api permissions tab
Add Api permissions and choose Power BI Services
Add delegated permissions for Tenant.Read.All
Grant the permissions

This worked for me!