Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Marcin
Helper V
Helper V

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, 

 

1234.png

 

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 7
v-qiuyu-msft
Community Support
Community Support

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 Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

 

this Analysis Services Azure model is created from Database that is also Azure Cloud Database. Maybe the reason is that I don't have access to that Database from home, but I have access to Analysis Services with the same credentials. 

 

I am using current version Power BI server 

Capture.PNG

Hey Marcin, do you have access to the logs for your Report Server? If so can you look at the latest RSPowerBI*.log after you have reproed the exception and let me know if you see any errors in the logs. Also for the analysis services model that you are connecting to, do you know if it is using DirectQuery vs. Cached configuration? Thanks!

edugonz
Frequent Visitor

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 username@company.com)?

 

Thanks!

-Eduardo

Hi,

 

I am using database credentials and login username as username@company.com . 

 

Marcin 

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.