Forum Discussion
Failed to resolve data sources error on Template App
Hi raiM ,
I think you should first make sure that the parameter "Model Location" in the Power BI report is properly configured to accept dynamic input from users when they install the application. This parameter should be set to allow users to specify the path to the Excel file on their SharePoint.
Next you need to check SharePoint permissions to make sure that all users who need to connect to their data have the necessary permissions to access the SharePoint folder where the Excel files are stored. Users should at least have read permissions to their respective files.
You should make sure that the path provided exactly matches the location of its Excel file on SharePoint, and finally I think you need to check this document: Get data from Excel workbook files - Power BI | Microsoft Learn
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Update:
I have installed the on-premises data gateway and it seems a step in the right direction. Now when i try to connect the new data source to the app I get a different error message:
Couldn't load the data for this visual
This operation is not allowed, as the database 'd1c1ae2a-f1a1-4f40-bef6-136f9c7e12dd' is in a blocked state. Please refer to https://go.microsoft.com/fwlink/?linkid=2159112 for more information.
-----------------
Hi Anonymous , thanks so much for your reply.
I will try to respond in order to your suggestion, so maybe we can find where I am making a mistake.
Anonymous wrote:I think you should first make sure that the parameter "Model Location" in the Power BI report is properly configured to accept dynamic input from users when they install the application. This parameter should be set to allow users to specify the path to the Excel file on their SharePoint.
I have set the parameter edit permissions to "Organizational" - I have also tried public or none but no change. If I am missing something here, please let me know.
Anonymous wrote:Next you need to check SharePoint permissions to make sure that all users who need to connect to their data have the necessary permissions to access the SharePoint folder where the Excel files are stored. Users should at least have read permissions to their respective files.
Yes, I set the excel file share permissions to my organisation as edit. Also I am testing this from my account, exactly to exclude this option, the same account local and on the power bi service. So the account should have access to the document, as it is the same account.
Anonymous wrote:You should make sure that the path provided exactly matches the location of its Excel file on SharePoint, and finally I think you need to check this document: Get data from Excel workbook files - Power BI | Microsoft Learn
Finally yes the path is correct and the document is the same that is running on the Power BI desktop, so the query is also correct (no column heading issue or similar)
This is why I am surprised, I am using the same document from the same account in the same location, and it is not working.
Either there is something I am missing or there is a permission issue that I am not aware of?
If you can help, it would be really appreciated.
Ray