Hi everyone, I am doing a report which carries many data sources (access file, excel files and D365CRM). The report is done in Power BI Desktop and refresh without any error. I uploaded the repo...
Hi ThuJa23 ,
In the course of our investigation, we found a similar thread. OP solved this problem in several ways.
- Set Privacy Level to Organizational. Make sure you have the same privacy level security in both Power BI Service and Power BI Desktop.
- Made sure all reports are refreshed at different times
- Created another on-premise gateway to split the load
- Created database tables rather than views to reduce processing between PowerBI and MSSQL
- Ensured both desktop and gateway has the latest version installed at all times
For more information, you may refer to:
'Unable to connect to data source undefined'
PowerBI intermittent Refresh Failure - Unable to connect to the data source undefined
Best Regards,
Community Support Team _ Caitlyn