MungBurger's avatar
MungBurger
Icon for Helper I rankHelper I
6 years ago
Status:
New

Unable to create paginated report from power bi dataset

I follow the instructions from https://docs.microsoft.com/en-us/power-bi/report-builder-shared-datasets   But when I get to posting the DAX query into the query designer - the designer is not availa...
Report Server
Reports
v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
6 years ago

MungBurger ,

 

There are currently a few limitations to using DirectQuery:

  • All tables must come from a single database, unless using composite models

  • If the Query Editor query is overly complex, an error will occur. To remedy the error you must either delete the problematic step in Query Editor, or Import the data instead of using DirectQuery. For multi-dimensional sources like SAP Business Warehouse, there is no Query Editor

  • Time intelligence capabilities are not available in DirectQuery. For example, special treatment of date columns (year, quarter, month, day, so on) is not supported in DirectQuery mode.

  • Limitations are placed on DAX expressions allowed in measures to ensure that queries sent to the underlying data source have acceptable performance.

  • There is a one-million-row limit for returning data when using DirectQuery. The limit does not affect aggregations or calculations used to create the dataset returned using DirectQuery, only the rows returned. For example, you can aggregate 10 million rows with your query that runs on the data source, and accurately return the results of that aggregation to Power BI using DirectQuery as long as the data returned to Power BI is less than 1 million rows. If more than 1 million rows would be returned from DirectQuery, Power BI returns an error.

 

Regards,

Jimmy Tao

Completed Ideas