Forum Discussion

tobiasgrossmann's avatar
tobiasgrossmann
New Member
9 years ago

Data Set above one million with filter

Hi Community,    I connected to an Azure hosted Database, the table I would like to built a report on has more then 1 mio entries. So I used a filter to restrict the result set. But seems like Powe...
Need Help
tobiasgrossmann's avatar
tobiasgrossmann
New Member
9 years ago

Hi Xiaoxin ,

 

  • Datasource type: Azure SQL Server
  • Connect mode: Direct Query
  • Create on service or desktop: PowerBI Cloud Version (not the desktop one)
  • Operation steps: Select a large table (over 3 Mio), add a Filter that sets the result-set to less then one mio, run and see the exception.

 

Now as I read that we even have the one mio restrictions on the desktop version in addition, swapping to this wont be a solution :-( Is there any way to order a change for this from microsoft? Like paying more for that function?

 

Or shall we use alternatives to PowerBI? Anything available from Microsoft, preferable in the cloud to solve our Buisness-Case?

 

Regards,

Tobi

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi tobiasgrossmann,

 

If you try to cut down your datasource size(100~200) and test to publish again, Does this issue appears again?

If it appears, it means the issue not related to your data size, please double check other settings.

 

Regards,

Xiaoxin Sheng