Paginated Report using Power BI service Data Source

Hej!

I'm trying to build a paginated report using a data set that I have produced as part of an app recently released. I am trying to use the same logic used in two of our Matrix visualisations (Which work) to produce the paginated report using a Matrix visualisation. However, when I am trying to run the query I get the error message that: "No rows found. Click to execute the query". 

Or when it actually loads data and I am able to run the query I get an additional error stating:

TITLE: Power BI Report Builder
------------------------------

The connection either timed out or was lost.

------------------------------
ADDITIONAL INFORMATION:

The remote server returned an error: (500) Internal Server Error. (System)

------------------------------
BUTTONS:

OK
------------------------------

The connection either timed out or was lost. (Power BI Report Builder)

------------------------------
Program Location:

at Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest(Boolean useBinaryXml)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.ExecuteStatement(String statement, IDictionary connectionProperties, IDictionary commandProperties, IDataParameterCollection parameters, Boolean isMdx)
at Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.IExecuteProvider.ExecuteTabular(CommandBehavior behavior, ICommandContentProvider contentProvider, AdomdPropertyCollection commandProperties, IDataParameterCollection parameters)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader(CommandBehavior behavior)
at Microsoft.AnalysisServices.AdomdClient.AdomdCommand.ExecuteReader()
at Microsoft.ReportingServices.QueryDesigners.ASDesigner.QueryBuilderClientControl.QueryExec.ThreadExecution()

===================================

The remote server returned an error: (500) Internal Server Error. (System)

------------------------------
Program Location:

at System.Net.HttpWebRequest.GetResponse()
at Microsoft.AnalysisServices.AdomdClient.HttpStream.<GetResponseStream>b__134_0()
at Microsoft.AnalysisServices.AdomdClient.HttpStream.ImpersonateLogonIdentityAndExecute(Action action)
at Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseStream()
at Microsoft.AnalysisServices.AdomdClient.HttpStream.GetResponseDataType()

What I am doing wrong? Are my data sets too large or do I need to recreate the relationships between the tables in the data source when using the report builder? 

Thankful for answers!