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

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.

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.