Don't do that anymore.
Use Management Studio to generate a script of all stored procedures/user-defined functions/tables:
-Right click your database
-Go to Tasks -> Generate Scripts
-Click Next, Next and chose Stored Procedures, user defined functions or tables.
Diagnosing Power BI DirectQuery Performance Problems Caused By SQL Queries
That Return Large Resultsets
-
One very common cause of Power BI performance problems is having a table
with a large number of rows on your report. It’s a problem I wrote about
here, and...
23 hours ago
0 comments:
Post a Comment