Forum Discussion
Resultset query Exceeded 1m Rows on measures unrelated direct query table.
I add new data sources all the time in tabular editor. (I use the paid 3 version but I think it would work in free 2 version).
I can send more detailed instructions when I get to a computer (away camping at the moment). Roughly though...
1) Right click add table.
2) Expand the partitions tree and there will be one with same name as the table.
3) Click on it and the M expression window should open.
4) In power bi desktop add datasource as normal and do any transforms you need.
5) Copy M code over into tabular editor from advanced editor.
6) Right click the table and click "update table schema".
6) Save back to service (I save to dev workspace and then deploy it along from there)
Thanks Ben, I'd love to be able to use TE but what happens when i need to add additional datasources in to the power query editor? (eg views/tables). As mentioned, Incremental refresh is the ideal but currently you can't download the PBIX when incremental refresh is set up (and if i need to add a datasource in, i need a local PBIX) UNLESS there's a way to do it in the service or in TE. I've not found a way... yet! 😄 happy to hear any suggestions. I have my Sales Fact on Import as it's currently 56m rows and the reports using it have many measures that make it super slow to load on direct query. Our customer table is also 30m rows (i've cut down to the bare minimum columns but we have a large customer base) and so i've had to also switch that back on to dual mode as when it was on direct q, that's when i was getting the initial error. Unfortunately, its the curse of the BI developer when your customer requires lots of KPI metrics to report on 😞
Community ChampionI add new data sources all the time in tabular editor. (I use the paid 3 version but I think it would work in free 2 version).
I can send more detailed instructions when I get to a computer (away camping at the moment). Roughly though...
1) Right click add table.
2) Expand the partitions tree and there will be one with same name as the table.
3) Click on it and the M expression window should open.
4) In power bi desktop add datasource as normal and do any transforms you need.
5) Copy M code over into tabular editor from advanced editor.
6) Right click the table and click "update table schema".
6) Save back to service (I save to dev workspace and then deploy it along from there)