Cant open a PBI report connected to a Dataset - connection issue

[sangrea]

Hi All

I have a very odd issue one of my the report.

for context:

- I have a dataset that access olap cube using live connection

- we did change source of dataset a month ago (server migration)

symptom is that when I tried to open a report from PBI Desktop, I get this error message and report will close. I cant even try to change the datasource. 

Odd thing is:

- that I have another report using the exact same dataset and I manage to open it. the only "difference" between the 2 is that I made several updates on the first report for the past few weeks while the one I cant open, I havent touch it for quite some time (no change since server migration).

- the databasename displayed is NOT the one currently configured for this dataset. Somehow, it seems that the PBI report keep information about the source behind the dataset.

- report refresh flawlessly on PBI Services. I tried to download the version from PBI Services and open it .. and no success

I am using PBI last version, already tried after logout, login again, I clear all recent and permission in global data source setting ... no success

Is there a way to open the report in some kind of "safe mode" so that I can still attempt to change the datasource ?

any other suggestions are welcome

thanks in advance for your help

Sang

[sangrea · Accepted solution]

hi all

I managed to find a solution to my problem.

restore the old database so that we can open R2.

create a new Dataset DS2, connecting to new database.

Have R2 connect to DS2 and then get back to DS1

we can now open R2 with old database off line.

There is definitely a bug somewhere in PBI when access data through a Dataset.

SD

[lbendlin]

I usually clear out all data source permissions in such a scenario, which then allows me to correct the connection details and to refresh the credentials.  Give that a try.

[sangrea]

hi @lbendlin 

thanks for feedback, but I already tried and this wont fix my pb.

le me try to give more detail on the condition:

I have 2 reports (R1 & R2) that connect to dataset DS1 as source of data

DS1 connect to an OLAP database DB1 (live connexion)

I push DS1 to PBI Service and use Gateway to access DB1 (that is in a private network)

Everything work juste fine.

a month ago, we changed DB1 to DB2

so we changed information in the gateway configuration and I changed DS1 to access DB2 and push again this "report" to PBI Service

DB1 has been shutdown

on PBI Services, 2 reports refresh correctly using data from DB2 

I can open and edit R1 using PBI Desktop

but I cant open R2 that is trying to reach DB1

Hope it clarifies

SD