Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello, I have made a Power BI Dashboard with Analysis Services (Live Connection). I have full access to the database and in Power Bi Desktop everything works (all data is visible and updated).
Then, when I publish the dashboard, and go to app.powerbi.com to open the DB, it gives me the error message that it cannot access the data source. "This report could not access its data source. please contact <Developer>, the author, to have it fixed." However, the gateway is set correctly and also connected to the corresponding dataset. What is noticeable is that the update date right after the publishing says: 1.1.53, 00:53:28. After the first gateway update it shows the correct date and time. Can anyone help me to fix the problem? Thank you very much!
Best Regard,
Nico
Solved! Go to Solution.
Hi @niras ,
Have you configured map user names for Analysis Services ?
Each time a user interacts with a report connected to Analysis Services, the effective user name is passed to the gateway and then passed on to your on-premises Analysis Services server. The email address that you use to sign in to Power BI is passed to Analysis Services as the effective user. It's passed in the connection property EffectiveUserName.
The email address must match a defined user principal name (UPN) within the local Active Directory domain. The UPN is a property of an Active Directory account. The Windows account must be present in an Analysis Services role. If a match can't be found in Active Directory, the sign-in isn't successful. To learn more about Active Directory and user naming, see User naming attributes.
You can also map your Power BI sign-in name with a local directory UPN.
To learn more details ,you could read the below:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas
And similar question refer(You can refer to their solutions):
https://community.powerbi.com/t5/Report-Server/Report-couldn-t-access-the-data-source/td-p/761986
https://www.sqlshack.com/direct-query-mode-in-power-bi-for-azure-analysis-services/
Wish it is helpful for you!
Best Regards
Lucien
Hi @niras ,
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
Hi @niras ,
Have you configured map user names for Analysis Services ?
Each time a user interacts with a report connected to Analysis Services, the effective user name is passed to the gateway and then passed on to your on-premises Analysis Services server. The email address that you use to sign in to Power BI is passed to Analysis Services as the effective user. It's passed in the connection property EffectiveUserName.
The email address must match a defined user principal name (UPN) within the local Active Directory domain. The UPN is a property of an Active Directory account. The Windows account must be present in an Analysis Services role. If a match can't be found in Active Directory, the sign-in isn't successful. To learn more about Active Directory and user naming, see User naming attributes.
You can also map your Power BI sign-in name with a local directory UPN.
To learn more details ,you could read the below:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas
And similar question refer(You can refer to their solutions):
https://community.powerbi.com/t5/Report-Server/Report-couldn-t-access-the-data-source/td-p/761986
https://www.sqlshack.com/direct-query-mode-in-power-bi-for-azure-analysis-services/
Wish it is helpful for you!
Best Regards
Lucien