report-server
1 Topic
Connect to Power Bi dataset from report server
Hi, this a fair recent issue I haven't been able to work around. There's a Power BI dataset I need to connect to and create reports that need to be published into a Report server. So far I can connect to it, either through the get data from Power Bi Dataset or from Azure analysis services, using the provided server link such as powerbi://api.powerbi.com/v1.0/myorg... It works in desktop September 2022, and it allows me to do what I need. The problem goes when I publish these into Report Server. It allows me to do so, and it even allows me to connect using a non MFA account and Basic authentication. However, I get this error when I open the report: Non-Windows user credentials were supplied for an non-http connection to Analysis Services. The Microsoft SQL Server Analysis Services data extension requires Windows Integrated Security unless connecting to Azure Analysis Services. That's ok, l can switch it to a Windows account and it seems to pass also the test connection side of the configuration. But if I open the report, this is what I get: We couldn't connect to the Analysis Services server. Make sure you've entered` the connection string correctly. The connection string is built like this: Data Source="powerbi://api.powerbi.com/v1.0/myorg/workspacename";Initial Catalog="datasetname";Cube=Model;Access Mode=readonly I'm not really sure where the problem is, and I feel this is something that is supported right now. The main reason for this is to allow us to publish massively reports on our report server from a data source created by analysts on the Power BI Online ServiceSolved7.6KViews0likes4Comments