Cannot edit Data Source Credentials after publishing .rdl file to PBI Service.

[Kallis]

Hello Expert/Technical Team,

I have developed a Paginated Report using PBI Report Builder and followed the steps in the below link from Microsoft Documentation.

https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-builder/connect-snowflake-databr...

Next, I published this Paginated Report to a Workspace within PBI Service where my remaining .pbix files also exists.

View a paginated report in the Power BI service - Power BI | Microsoft Learn

So far, I didn't have any issues with DataSource Credentials of .pbix files as under Manage option, it is enabled under Semantic Models Tab. Here developer can edit credentials.

Where as for .rdl files, these should be shown under Reports Tab as shown in the Microsoft Documentation below. But this Report tab is missing. When I try to click on Manage option from the ellipses of .rdl file, I am able to view .rdl files. But, DataSource Credentials is disable/greyed out.

Publish a paginated report to the Power BI service - Power BI | Microsoft Learn

https://learn.microsoft.com/en-us/power-bi/paginated-reports/paginated-reports-save-to-power-bi-serv...

In this above link,

Step 3: I uploaded the .rdl file to Service.

Step 4: Clicked on Manage under ellipses.

Step 5: Here is the problem, Reports Tab itself is missing(in the below image) which would not allow me to Edit Credentials.

If we understand that in the latest versions, Report Tab is removed and directly we can Edit Credentials from Data Source Credentials even then under the Report directly this option is disabled/greyedout as shown in below screenshot.

Timely help is much appreciated.

Thank you very much.

Regards

Kallis

[Anonymous · Accepted solution]

Hi @Kallis 

Based on your description, please chect that if your data source needs the gateway, if it needs the gateway, you sholud add the datasource to the gateway first,  you can refer to the following link.

Add or remove a gateway data source - Power BI | Microsoft Learn

And you can also refer to the following link.

Publish .rdl files to Power BI from Power BI Report Server and Reporting Services - Power BI | Micro...

Best Regards!

Yolo Zhu

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