Forum Discussion

Sujit_Thakur's avatar
Sujit_Thakur
Solution Sage
5 years ago
Solved

SQL SERVER DIRECT QUERY

Dear All , My data source is SQL Server , which instance is created in RDS from AWS .   Now when I am importing a view from database  using direct query mode , till this everything is fine , bu...
Need Help
  • Sujit_Thakur's avatar
    Sujit_Thakur
    5 years ago

    Thanks all ,. for replying .
    After reading Power BI Documentation it was clear that like normal import mode it is not possible to work on data in power query editor , because as every time i move a slicer , PBI queries data on point from SQL Server.
    Hence what i did was i did the steps in python where i used to process data before taking it in power bi

    then it worked thanks all

     

NimaiAhluwalia's avatar
NimaiAhluwalia
Continued Contributor
5 years ago

Hello Sujit_Thakur 

 

If you are using Direct Query please keep the following things noted when creating the model!

 

The term modelling in this context means the act of refining and enriching the raw data, as part of authoring a report using it. Examples include:

  • Defining relationships between tables
  • Adding new calculations (calculated columns and measures)
  • Renaming and hiding columns and measures
  • Defining hierarchies
  • Defining the formatting, default summarization and sort order for a column
  • Grouping or clustering values

 

You are getting this error due to some limitations you are trying to use with Direct query.

 

For more reference refer to this

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

 

IF MY SOLUTION HELPED YOU IN SOME OR THE OTHER WAY PLEASE DO HIT A LIKE AND ACCEPT IT AS A SOLUTION IF IT RESOLVES FOR ERROR!