There was an error communicating with Analysis Services + Maximum size allowed size of 1000000 rows
I have created a paginated report using Power BI dataset which has a composite model Direact Query (Dataflows) and Import Mode (Snowflake) and enabled deafult download of Paginated report to excel. Using slicer values of Power BI report as query parameters for Paginated report (Concatenated slicers values with Paginated report url and assinged it to action of button for downloading). For Members of workspace Paginated report works as expected. When a user with viewer tries to download paginated report from Power BI report, facing following error. Below failed attempts made: 1. Added build permission to dataset. 2. Maintained same privacy levels for both the datasources. In Power BI desktop as well as in Power BI service. 3. I have agg tables to take the load of Direct query data. 4. Tried XMLA endpoint as source for Paginated report. 5. Updated PowerPlatformdataflows datasource credentials. Thanks in advance.
Power BI report server Direct query: getting data form one direct query to another direct query
Hi Team, I have 3 tables one with Employee detail(employee ID, Name, Email columns) --> this table accessiable to all. data_access (employee and city) and another table with Country_revenue (Country, continent, revenue amount columns) deatils --> these table is accessible only for specific account when we pass the employee Id in the SQL pacakge(Pkg_data.country_data (Email)) I tried 1. DAX fucntion Userprincipalname to use as a parameter, but direct query (power editor) doesn't support it. 2. list.max but 'Failed to save modifications to the server. Error returned: 'DirectQuery partition 'xxxx-x56565x7575757575x757575' has '2' datasource reference(s) in its expression which is not allowed. '' Can you please help, how to pass Email into this?
