topic Re: PowerBIResAPI: Dataset failing with Invalid credential : (Mez file, M code, Gateway connection) in Developer

PowerBIResAPI: Dataset failing with Invalid credential : (Mez file, M code, Gateway connection)

RajCZ — Sat, 02 Nov 2024 16:48:44 GMT

I have two Semantic models(connecting with PowerBIRESP API via MEZ file) , Connector(MEZ file) is setup on Gateway server..

one needs admin permission on PowerBI API and another doesn't need. both are setup 100% same way, only difference is one pulling Power BI metadata that needs admin permission.

while refreshing, "admin" one failing with "Invalid Credential"

Connector(MEZ file) is setup on Gateway server.

Now different credentials are here

Service principal and client secret are saved inside connector to be used by M Code.
We have added credentials on Power Bi Gateway connection while creating a gateway connection that is used by Semantic model to use gateway.
User’s credentials who manually logged to Power bi and hit model refresh button.

IF Model returns “Invalid credentials", then what credentials are invalid. What is role of each credential.

What credentials are actually being sed to pull Power bi metadata.

Re: PowerBIResAPI: Dataset failing with Invalid credential : (Mez file, M code, Gateway connection)

RajCZ — Sat, 02 Nov 2024 21:52:01 GMT

4th credential is userid/service id logged on Power bi Gateway.

Re: PowerBIResAPI: Dataset failing with Invalid credential : (Mez file, M code, Gateway connection)

tharunkumarRTK — Sun, 03 Nov 2024 03:57:09 GMT

@RajCZ

Considering you have service principal id and secret hardcoded in the M code of .MeZ file, you dont need to enter any other credentails while configuring the gateway connection. You can use anonymous authentication.

Power BI user credentials and the service account used for gateway installation has nothing to do with the data refresh failure due to invalid credentails.

Need a Power BI Consultation? Hire me on Upwork

Connect on LinkedIn

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!