Power bi

[09avinash]

I am unable to import sql server data to my powerbi desktop.my datasets is too large.what should I do for that

[Idrissshatila]

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]

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.

[Anonymous]

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

[Idrissshatila]

@09avinash ,

Then try direct query connection,https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery

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

Follow me on Linkedin
Vote For my Idea 💡

[09avinash]

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