Failed to preview report.

[PanktiChokshi]

I am trying to develop paginated report. I have created shared dataset on Power BI Report Server. While working on the report using Report Builder, I am able to connect to shared dataset successfully, then I have added dataset but upon clicking the run button, I receive a "Failed to preview" error message.

[v-pagayam-msft]

Hi @PanktiChokshi ,

Glad that your query has been resolved. If our community member's response addressed your question, please Accept it as  Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[PanktiChokshi]

Its not resolved yet.

[MLITTLE]

I also have the same issue occuring. If any further suggestions on resolution, that would be appreciated.

[v-pagayam-msft]

Hi @PanktiChokshi ,
Thank you for reaching out to the Microsoft Fabric Community Forum regarding the issue you're facing.

I kindly suggest the following steps that might help you resolve the issue

1.Verify the data source settings and make sure the credentials have sufficient privileges for the task.

2.Run the query directly in the database to check whether it executes correctly.

3.Check and correct the parameter definitions and mappings in the dataset properties.

4.Verify that all fields used in the report are available in the data set and update the report if required.

5.Migrate to the latest version of Report Builder to have the benefits of bug fixes and updates.

I tried with the sample data and providing the screenshot of preview below for your reference.

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

[PanktiChokshi]

I am able to develop the report, however, when I attempt to execute it by pressing the run button, I encounter a "Failed to preview" error. I have uploaded the report to Power BI Server, where it functions correctly.

[v-pagayam-msft]

Hi @PanktiChokshi ,
Thank you for the response.
Could you please provide the screenshots of the errors. Also, kindly outline the steps you followed in detail.

If you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @PanktiChokshi ,
I wanted to check and see if you had a chance to review my previous message or Please let me know if everything is sorted or if you need any further assistance.

Thank you for being a part of the Microsoft Fabric Community Forum!
Regards,
Pallavi

[MLITTLE]

Hi,

This is the screenshot of the error I am getting.
I think it may be the as you suggested the report doesn't have permission for the sharepoint location where the data is stored, but it is public/open to organisation, so not sure what else I can do to give permission?

[v-pagayam-msft]

Hi @PanktiChokshi ,
Thank you for your response.
Since the report works correctly on the Power BI Server but fails to preview in Report Builder, here are a few steps which might help you to resolve the error.

1.Check the Report Builder version you are using is fully compatible with the Power BI Report Server version.
2. Verify the data source configuration in Report Builder, as settings might differ between the server and local environment.
3. Confirm there are no network issues or firewall settings blocking the connection when previewing the report locally.
4. Simplify the report by reducing the data size to check if the preview works.
5. Check all necessary database drivers on your local machine are up to date.

Please feel free to reachout for further assistance. If this post helps, please Accept the answer so that it will be helpful to others to find it quickly.

[PanktiChokshi]

I began encountering this error when utilizing a shared datasorce. When I do not use a shared datasource, I can preview the report without any issues. However, the moment I incorporate the shared dataset, the error occurs.

I confirmed this by using a standard SQL connection, which functions properly and allows me to preview the report. So I belive that the database drivers are not the the problem.

Furthermore, I tried importing the shared datasource, assigned a standard title, and ran the report, but I encountered the same error. It is worth noting that since the dataset has not been added, size should not be a concern.

[v-pagayam-msft]

Hi @PanktiChokshi ,
From the information  provided, it looks like the issue might be related to the configuration or permissions of the shared datasource. Here are some reasons that might help you.

1.Shared datasource might not have the necessary permissions to access the data when the report is run.Check the permissions.
2.Double-check the configuration settings for the shared datasource.
3.Clear any cached data in Report Builder which might cause issues when previewing newly created reports.

If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you for being a part of Microsoft Fabric Community Forum!