Forum Discussion
Solved
Missing Connection Details - Dataverse
- Hi, I have an error like the following: I have created report usign Dataverse connection and pulished to the on prem server ( we are not using Power BI Services) I am getting following error. How do I resolve this issue. Data Source tab also disabled and Schedule Refresh tab having below error.
Thank you
- This is a Power BI Report Server limitation, not a normal credential issue.In Power BI Report Server, scheduled refresh is only available for Power BI reports with an embedded/import model and with data sources that support scheduled refresh in Report Server.The error message is telling you that the report either has no supported external data connection or is using an unsupported data source. And i can guess that you choose "Dataverse" with get data in Power BI Desktop Optimized for Report Server, and if you looked closely at the auth box, it does say common data service. => not support scheduled refresh for report server.
=> not support auth methods of report server.Reference:Scheduled refresh in Power BI Report Server is much more limited than in the Power BI Service. If you need scheduled refresh directly from Dataverse, the supported option is usually to publish the report to the Power BI Service instead.If you must stay on Power BI Report Server, the usual workaround is to stage the Dataverse data into a supported source first, for example SQL Server, and then build the PBIRS report from that SQL Server source.So the practical options are:- Use Power BI Service for the Dataverse-connected report- Or move/sync Dataverse data into SQL Server or another PBIRS-supported refresh source- Or manually refresh in Power BI Desktop Report Server edition and republish the PBIX🔍Parchitect
Solutions Architect · Microsoft Fabric Specialist💡Helpful? Kudos are appreciated.
✔️Solved? Mark as Solution so others can find it faster.
2 Replies
- This is a Power BI Report Server limitation, not a normal credential issue.In Power BI Report Server, scheduled refresh is only available for Power BI reports with an embedded/import model and with data sources that support scheduled refresh in Report Server.The error message is telling you that the report either has no supported external data connection or is using an unsupported data source. And i can guess that you choose "Dataverse" with get data in Power BI Desktop Optimized for Report Server, and if you looked closely at the auth box, it does say common data service. => not support scheduled refresh for report server.
=> not support auth methods of report server.Reference:Scheduled refresh in Power BI Report Server is much more limited than in the Power BI Service. If you need scheduled refresh directly from Dataverse, the supported option is usually to publish the report to the Power BI Service instead.If you must stay on Power BI Report Server, the usual workaround is to stage the Dataverse data into a supported source first, for example SQL Server, and then build the PBIRS report from that SQL Server source.So the practical options are:- Use Power BI Service for the Dataverse-connected report- Or move/sync Dataverse data into SQL Server or another PBIRS-supported refresh source- Or manually refresh in Power BI Desktop Report Server edition and republish the PBIX🔍Parchitect
Solutions Architect · Microsoft Fabric Specialist💡Helpful? Kudos are appreciated.
✔️Solved? Mark as Solution so others can find it faster. thank you for your response.
