Power BI Template App Publishing Issue (Test link Installation- Failed to Import Data)

[navneet_07]

Hi @all,

I’m currently encountering an issue while publishing a Power BI Template App. The data source for my reports is Excel files stored in my organization’s SharePoint. I’ve parameterized the source paths so that other users can connect to their respective data sources during installation. Privacy is set to "Organizational", and the authentication method is "OAuth2".

I followed the official Microsoft guide: Create template apps in Power BI - Power BI. to build and configure the template app. However, after generating the test link, the app didn't get installs & throws the following error:

I have perform few checks:

1. Edited data source credentials directly in the workspace settings.

2. Successfully refreshed the semantic model in the template workspace — no issues observed.

3. Verified all parameter default values — everything appears valid and functional.

4. In the "Create App" configuration:

• Authentication method is set to OAuth2

• Access level is Entire Organization

5.Error status code is 200, which makes it harder to pinpoint the failure.

Despite these checks, I’m still stuck with the import error. If anyone has encountered a similar issue or can help identify what I might be missing, your suggestions would be greatly appreciated.

Thanks in advance!

[Anonymous]

Hi @navneet_07,
Great to hear that it's working as expected on your end!. I would suggest accepting your approach as the solution so that it can benefit others as well. It would be really helpful for others in the community who might be facing similar issues and can address them quickly.

Thanks & Regards,

Prasanna Kumar

[Anonymous]

Hi @navneet_07,

Just following up to see if the solution provided was helpful in resolving your issue. Please feel free to let us know if you need any further assistance.

Best regards,

Prasanna Kumar

[navneet_07 · Accepted solution]

Hi @Anonymous,

I tried your suggestion of using two separate parameters, but unfortunately, it didn’t resolve the issue. I also explored several other possible options, but none of them were fruitful.

Eventually, I rebuilt the entire report from scratch and applied the same settings as before to configure it for the template app. This time, it worked without any issues.

From this experience, I believe the problem may have been caused by switching the data source—initially from Business Central  to Sharepoint—by duplicating the original file. This change might have introduced underlying conflicts that affected the installation of the template app.

Nevertheless, thank you for your assistance!

Regards,
Navneet Prajapati

[Anonymous]

Hi @navneet_07,

Thank you for reaching out to the Microsoft Fabric Forum Community.

Try below troubleshoot steps to resolve the issue:

Use two separate parameters, one for the SharePoint site URL and another for the file name, and filter the file inside Power Query using SharePoint.Files.

Ensure these parameters are visible during app installation, allowing users to enter their own site and file values.

Confirm the Excel file actually exists at the path entered by the user during installation. Test the installation with a different user account to check if the issue is specific to your credentials or permissions.

Kind regards,
Prasanna Kumar

[Anonymous]

Hi @navneet_07,

Thanks for reaching out to the Microsoft Fabric Forum Community.

Can you confirm what type of connection you're using to access the Excel files is it the SharePoint Folder connector or the Web connector?

Thanks & regards,
Prasanna Kumar

[navneet_07]

Hi @Anonymous ,
Yes, I am using SharePoint Folder connector currently.