the order value is missing after schedule refresh power bi report server

[Meng]

in power bi desktop, i can see the order value from order table in visuals, also can see it after uploading the pbix file to power bi report server Web URL. however ,only  the order value is missing after schedule refresh,  the other measure values from other tables are normal.

and i referred to the docment :https://docs.microsoft.com/zh-cn/power-bi/report-server/scheduled-refresh-troubleshoot ,

Power BI report scheduled refresh in Power BI Report Server - Power BI | Microsoft Docs.

the first one is to say i can't use the data via Enter Data way?

the second one is to say i can't use parameter to replace data source IP and database name?

please let me know how to solve this problem, i also need order value after schedule refresh, thank you so much!

Best regards

Amy

[Icey · Accepted solution]

Hi @Meng ,

// 1. the first one is to say i can't use the data via Enter Data way?

I have tested with a report connected with SQL Server database via Import mode and enter an order table. But it works well.

Could you share some deatils such as screenshots or sample files for test? Please don't contain any sensitive information.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

// 2. the second one is to say i can't use parameter to replace data source IP and database name?

You can use parameter to replace data source IP and database name on Power BI Desktop. But it won't work when the file is uploaded to Power BI Report Server. Only data sources that are detected when the report was uploaded can be refreshed. You can't change the data source after it is uploaded to PBIRS.

Best Regards,

Icey

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

[Icey · Accepted solution]

Hi @Meng ,

// 1. the first one is to say i can't use the data via Enter Data way?

I have tested with a report connected with SQL Server database via Import mode and enter an order table. But it works well.

Could you share some deatils such as screenshots or sample files for test? Please don't contain any sensitive information.

Reference: How to provide sample data in the Power BI Forum - Microsoft Power BI Community

// 2. the second one is to say i can't use parameter to replace data source IP and database name?

You can use parameter to replace data source IP and database name on Power BI Desktop. But it won't work when the file is uploaded to Power BI Report Server. Only data sources that are detected when the report was uploaded can be refreshed. You can't change the data source after it is uploaded to PBIRS.

Best Regards,

Icey

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

[Meng · Accepted solution]

Dear Icey,

 Thank you for the perfect reply, happy to say the issue has been solved. it is bacuase the customer haven't clarify the key information, it is another one instead of the issue above, thanks. 

[Icey]

Hi @Meng ,

Glad to hear the issue is gone. Please accept your reply as the solution. Your contribution is highly appreciated.

Best Regards,

Icey