Forum Discussion
Data source connection issue
Hi,
I have installed today Power BI report server and published two reports with SSAS on Azure as data source. I set my credential to data source on webportal manage report, connection test was successfull .
The problem is when I try to use those reports from home where I have no connection to company network,
I am able to use in the same time PowerBI service, office365 portal etc . because I used proper authentication process, but only this report portal is not working as mentioned.
7 Replies
Hi Marcin,
a couple questions, are you using database credentials or windows credentials for your datasource? also what's the username format (this can be either domain\username or [email protected])?
Thanks!
-Eduardo
Hi Marcin,
When you mention you get data from "SSAS on Azure", do you mean it's Azure analysis services or SSAS instance installed in Azure VM?
Best Regards,
Qiuyun YuHi,
I use Azure analysis services , we don't have any on-prem serwers at this moment in my organization or VMs.
Hi Marcin,
Was this Azure Analysis Service model created from the on-premise SQL database or Azure SQL database? If it's Azure SQL database, based on my test the report can display with correct database credential entered. If it's on-premise database, please try to set gateway and make gateway online: On-premises data gateway.
By the way, please try to run Power BI report server GA version 14.0.600.286.
Best Regards,
Qiuyun Yu
