Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

PowerBi update 2019 January Direct Query Error!!!!

Hi all,   We updated the Power BI Report Server with Jan'19 version and we are taking the direct query error. The reports open the Power BI Desktop (January 2019) with no issue. After we save as th...
PBI Report Server Jan'19 Update
mpsrshl's avatar
mpsrshl
Advocate II
7 years ago

Hi compatriota,

 

Are you using a direct query to a data source and imported data to another one in your data model? 

 

if this is the case: 

PBIRS does not allow the module you have setup in your dashboard. Direct query and Imported data is a dual feature (Composite Models) it only exists in the cloud service for now. If you want to make it work, you will have to turn all data streams into "import mode" and then set scheduler on the properties of the dashboard inside the Report Server "Manage" section. 

 

If all your data is imported into the PBI file: Re-enter the credentials inside the PBI file by deleting your connection strings and re adding them in lowercase (Servername/InstanceName). Upload PBI file back to the Report Server and see if it works. 

 

Hope it helps. 

 

Marce

mahias's avatar
mahias
Frequent Visitor
7 years ago

Good afternoon marce

Thanks for answering my question, you have an email to contact you.

regards

Eduardo

 

Buenas Tardes Marce

Gracias por responder a mi consulta, tienes algún email para poder contactarte.

Saludos

Eduardo

  • mpsrshl's avatar
    mpsrshl
    Advocate II
    7 years ago
    You can pm me. Cheers