keep asking for Credentials in the middle of report refresh in PowerBI desktop

[savitamittal]

I created a report in PowerBI desktop and when I try to refresh the report to apply all changes, it keeps popping window asking for credentials in the middle of report refresh after it has pulled partial rows.  Any help would be appreciated.

Thanks!

[v-jingzhang · Accepted solution]

Hi @savitamittal 

Which version of Power BI Desktop are you using? Can you install the latest version, clear permissions and try again? And if possible, test whether this happens on multiple computers or only on one computer.

Reference:

Azure Synapse Analytics (formerly SQL Data Warehouse) with DirectQuery - Power BI | Microsoft Docs

Power Query Azure Synapse Analytics (SQL DW) connector | Microsoft Docs

Regards,
Community Support Team _ Jing

[savitamittal]

I am connecting to Synapse DW

[amitchandak]

@savitamittal , What is datasource you are connecting with? I have not seen this behavior.

Go to Transform data -> Edit datasource -> clear permission and give the details once more and try