topic Re: Problem with scheduled refresh of a report in power bi report server october 2020 rectified rele in Report Server

Problem with scheduled refresh of a report in power bi report server october 2020 rectified release

Anonymous — Wed, 02 Dec 2020 17:04:09 GMT

i have problem when refreshing my reports in power BI report server october 2020 rectified release.

I got this error:

The credentials provided for the SQL source are invalid. (Source at .). The exception was raised by the IDbCommand interface.

Any one have a solution for this problem?

Re: Problem with scheduled refresh of a report in power bi report server october 2020 rectified rele

DavisBI — Thu, 03 Dec 2020 03:53:50 GMT

Hi, @Anonymous ,

You can refer to this thread

Re: Problem with scheduled refresh of a report in power bi report server october 2020 rectified rele

Anonymous — Fri, 04 Dec 2020 10:05:09 GMT

thank you very much for your interest

But ,this thread couldn't solve my problem

the same error still existing

Re: Problem with scheduled refresh of a report in power bi report server october 2020 rectified rele

Dearc — Thu, 10 Dec 2020 00:56:32 GMT

Please try "Repair" the report server after back up all the config files.

Re: Problem with scheduled refresh of a report in power bi report server october 2020 rectified rele

Anonymous — Thu, 10 Dec 2020 07:45:02 GMT

i tried "Repair" the report server but the same error

bu what do you mean from "after back up all the config files." from where i can get the backup file?

Re: Problem with scheduled refresh of a report in power bi report server october 2020 rectified rele

Dearc — Fri, 11 Dec 2020 01:04:58 GMT

Try steps as below,

Back up config files from c:/windows/program files/powerbi server/*/*.config
"Repair" the report server
Uncheck the "Enhanced metadata format" for .pbix files
Re-publish .pbix files

This thread at here may help.

Re: Problem with scheduled refresh of a report in power bi report server october 2020 rectified rele

Anonymous — Fri, 18 Dec 2020 14:00:26 GMT

thank you very much

Re: Problem with scheduled refresh of a report in power bi report server october 2020 rectified rele

mgmeyer — Fri, 18 Dec 2020 22:04:17 GMT

@Anonymous can you tell me a little bit about the reports that you have that are running into this issue? For example:

1. What type of datasources do you have (I assume SQL but are there more)?

2. What type of auth are you using for those datasources?

3. Does the issue repro intermittently or all the time?

4. Which version of the server to do you have installed? We published a QFE with a couple fixes, have you installed it?

5. Can you share the failures in your RSPower* and ASManagedRoot* logs (you can private message me if you want)?

Thanks!

Re: Problem with scheduled refresh of a report in power bi report server october 2020 rectified rele

Anonymous — Mon, 04 Jan 2021 14:07:33 GMT

Hello,

Sorry to non reply early

1- the datasourses type is sql server

2- i'm using sql auth

3- the issue repro all the time

4-the last version october 2020 and i have also installed the vesion pblished in november

Re: Problem with scheduled refresh of a report in power bi report server october 2020 rectified rele

mgmeyer — Tue, 05 Jan 2021 01:39:23 GMT

@Anonymous thanks for the update, couple more questions:

1. How many datasources do you have in the report?
2. If there is more than one are they all SQL Server?

3. If you go to the Datasource setting in Desktop if you click edit permissions what do you have set for the properties in there (e.g. Credential Type, Encryption, Privacy, Native Queries)?
4. When you go into the power query editor how many queries to you have in there?

5. Can you share the failures in your RSPower* and ASManagedRoot* logs (you can private message me if you want)?

Also I sent you a private message with my contact info, if possible i'd like to get on a call to help debug this issue. Thanks!

Re: Problem with scheduled refresh of a report in power bi report server october 2020 rectified rele

Anonymous — Tue, 05 Jan 2021 07:43:28 GMT

Hello,mgmeyer

1- i heve reports with one data sources and reports with more

2- yes sql server

3- Can you see the example in the attachement

4- i have many reports but for exemple , the report in the previous attachement has 43 query

and i have reports with 1 datasource and few query where i have the same problem

5- sorry i don't understand how

Re: Problem with scheduled refresh of a report in power bi report server october 2020 rectified rele

mgmeyer — Tue, 05 Jan 2021 22:30:19 GMT

The log files should be in the install folder of your server if you have access to it, should be in something similar to the following:

C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles