facing issue while connecting with API-JSON URL as source

[Vaishnav]

Hi am getting below mentioned error while publishing report to my workspace,

Data Source: web URL with API JASON, which holds the data needs to be loaded in Power Bi desktop

Error_1: Your file was published, but disconnected
Error_2: unable to access the data source beacuse the artifacts is kissing connection details. Connect with Artifact owner to bind the data source to data connection OR use default connection settings for the unbound data source.

[v-bmanikante]

Hi @Vaishnav ,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @Vaishnav ,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @Vaishnav ,

We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?

If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.

Regards,

B Manikanteswara Reddy

[v-bmanikante]

Hi @Vaishnav ,

Thank you for reaching out to Microsoft Fabric Community Forum.

@Akash_Varuna Thank you for your quick reply.

It looks like the issue you're facing—"Your file was published, but disconnected" and "Unable to access the data source because the artifact is missing connection details"—usually happens when Power BI Service can't find or recognize the data source connection details after you publish a report, especially when using a Web API (JSON).

• Here are a few steps you can try to fix it:

Update credentials in Power BI Service

• Go to your workspace in Power BI Service

Find the dataset, go to Settings > Data source credentials, and re-enter the correct authentication info.

• Use anonymous authentication (if the API doesn’t require auth)

In Power BI Desktop, make sure you're connecting to the Web API with the correct authentication method (e.g., Anonymous).

• Clear Power BI Desktop cache

Go to File > Options and settings > Options > Data Load, and click Clear cache, then restart Power BI.

Please check the URL below—it describes a similar issue and might help you troubleshoot your situation:

https://community.fabric.microsoft.com/t5/Desktop/API-JSON-link-issue/m-p/112276

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,

B Manikanteswara Reddy

[Akash_Varuna · Accepted solution]

Hi @Vaishnav It might be because of missing or incorrect data source credentials in Power BI Service, especially for API authentication. Check and update the credentials under Settings > Datasets > Data Source Credentials. Ensure the API URL and headers are properly configured in Power BI Desktop. If the API requires a gateway or token refresh, set them up in Power BI Service to resolve the issue.