Failed to build connection in pbi service

[Thas_Michael]

I'm checking your support to understand the connection failed over when I need to build new connections.

I can input the credential of the old connection, but not for new one. Please advice,

Session Id: 5e53cb8d-e63b-4ba0-a079-d053f74f722b

RequestId: 02fdd56c-425d-4b4b-a67e-dc2809b796d8

Cluster URI: https://api.powerbi.com

Status code: 400

Time: Tue Oct 15 2024 15:41:38 GMT+0700 (Indochina Time)

[Thas_Michael]

Thanks All for your input,

Actually I still didn't find why the existing connection working well with user/pwd authentication in existing report, but not able to create new connection with different directory in (folder/ file/ sharepoint...). 

@Anonymous can you check more whether any restriction in Admin role to revoke create new connection? 

If no stoper, we can have quick sharing on Monday Oct 21 2024, at 11AM China-time?

Join the meeting now

Thanks again,

Thanh

[Anonymous]

Thank you sergej_og and mohitkumawat 

Hi, @Thas_Michael 

The status code is 400, which means that the Power BI service cannot connect to your data, your data source is not unreachable.
Here are the steps you need to take:
You need to make sure that the credentials provided are the same as in Power BI desktop:

Solved: Re: Status 400 Error when setting up an SQL Gatewa... - Microsoft Fabric Community

Please ensure that the credentials you provide currently have sufficient permissions to access the contents:

Additionally, you need to ensure that your data sources do not intercept requests to the Power BI service.

Best Regards

Jianpeng Li

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

[Thas_Michael]

Hi Jianpeng,

Actually I tried to apply the same credential with multiple-existing connections (folder/ sharepoint), it worked well. 

I'm checking whether any feature of admin to stop us defining new connection in PBI service? If yes, please help to share screen-shot,

Thanks,

Thanh

[Anonymous]

Hi, @Thas_Michael 

If you create a gateway connection to Sharepoint, you only need to check whether you have the appropriate permissions to access the data in it. You can check it by following the steps of the official documentation:

Power Query SharePoint folder connector - Power Query | Microsoft Learn

Try to connect SharePoint via the gateway:

Try to connect SharePoint via the cloud:

Check that the following options are turned on:

Best Regards

Jianpeng Li

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

[Thas_Michael]

If no stoper, we can have quick sharing on Monday Oct 21 2024, at 11AM China-time?

Join the meeting now

[Anonymous]

Hi, @Thas_Michael 

If you need online phone support, you can click on the link below to open a ticket:

Microsoft Fabric Support and Status | Microsoft Fabric

Share your solution here and mark it as a solution to help others in the community. When sharing solutions, remove sensitive information.

Best Regards

Jianpeng Li

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

[Thas_Michael]

Hi @Anonymous ,

It looke my account limited access to raise request, can you check and guide how to enable this feature?

Thanks,

Thanh

[Anonymous]

Hi, @Thas_Michael 

Maybe you can learn how to raise a support ticket from the tutorial below:

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

[Thas_Michael]

Hi @Anonymous ,

I'm checking with User_admin role,

Meanwhile, can you access team link and have quick discussion?

https://teams.microsoft.com/l/meetup-join/19%3ameeting_MmE3NWQxMTItOWY4Mi00YzJjLTkwN2MtZGYyODk0MDA0Zjg1%40thread.v2/0?context=%7b%22Tid%22%3a%2215ccb6d1-d335-4996-b6f9-7b6925f08121%22%2c%22Oid%22%3a%2256ea2f40-53a3-415f-b58d-75d5b1e4d2f2%22%7d

Thanks,
Thanh

[Anonymous]

Hi, @Thas_Michael 

I don't have permission to join teams meetings. You can raise a ticket so that my colleagues in other departments can respond to you immediately. They will discuss your issue with you online and solve it.

Best Regards

Jianpeng Li

[Thas_Michael]

Hi @Anonymous ,

Actually I'm not in Admin role, I think it not enable feature to raise request. 

Can you share me your personal email? Can we have quick call at 3:15PM China time.

Thanks,

Thanh

[Anonymous]

Hi, @Thas_Michael   

Thank you very much for your reply.

This is probably because the administrator in your organization has set a policy that prevents you from logging in. You can check the following post:

Azure sign-in error 53003. "Access has been blocked by Conditional Access policies" and Conditional ...

If you need online technical support, you need to ask your administrator to open a support ticket.

Best Regards

Jianpeng Li

[sergej_og]

Hey @Thas_Michael ,
what do mean by "build new connections"?
Creating new connections in Power BI gateway (in Service)?

Pls provide more information what are you aiming to achieve.

[mohitkumawat]

Hi, 
Your error indicates that the data source credentials are not correct.
 if you use the Power BI Gateway, this error typically indicates a "Bad Request." It can occur due to authentication issues