Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi.
I would like to schedule a resfresh everyday for my data. My data is imported from a SQL-database - it is a CRM system.
I have tried to login through different authentications but it will not connect to my data source. What should I do?
Best regards,
Lisa
Hi, @Anonymous ;
And is it Personal or Enterprise?
Configure scheduled refresh - Power BI | Microsoft Learn
Your authentication here needs to be the same as when the desktop links the data source. Generally, we use window or basic authentication.
Make sure that the user name and password are correct.
Secondly, this is import mode, not Directquery, right? If it is import, you can try the personal gateway.
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yalanwu-msft.
It is Enterprise. I tried to use both basic and windows but it just keep loading.
It is import - I just dont understand the personal gateway.
Best regards,
Lisa
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 63 | |
| 55 | |
| 42 | |
| 41 | |
| 23 |
| User | Count |
|---|---|
| 167 | |
| 136 | |
| 120 | |
| 79 | |
| 54 |