Forum Discussion

09avinash's avatar
09avinash
Frequent Visitor
2 years ago

Power bi

I am unable to import sql server data to my powerbi desktop.my datasets is too large.what should I do for that
Need Help
Idrissshatila's avatar
Idrissshatila
Super User
2 years ago

Hello 09avinash ,

 

Try creating views that with dimension and fact tables, where you alsoget only the columns you need and you may filter the data to get what is required for the analysis, not just  take everything into power bi.

 

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea 💡

 

09avinash's avatar
09avinash
Frequent Visitor
2 years ago

I already did which you replied me.

The problem is that the data is too large after creating views and filter the column its take too many time to import in power bi desktop and finally return with error with timeout.

 

    • 09avinash's avatar
      09avinash
      Frequent Visitor
      2 years ago

      No i have to use import mode.because i have to make lots of measures. Calculate column so i can't use direct query

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi 09avinash ,

    1. Please try manually set timeout of the report to 120min.

    2. Only bring the columns that you need. Exclude high cardinality, free-form text fields and consider rounding high-precision values.
    3. Break Apart 'Composite' Fields: For example, convert timestamps to hours, minutes, seconds. This reduces cardinality.

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum