Limitations of using SQL Server Function as data source for Power BI

Anita Rani 0 Reputation points
2024-02-07T13:44:27.24+00:00

We in our company want to use SQL Server Object Functions as a data source for Power BI like we use Views, Stored Procedures etc. Since Functions are not used much as data source like Views, can anyone, who have already used functions guide us about their limitations in Power BI? Thank you Anita Scalability Engineers Pvt. Ltd.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,629 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 43,901 Reputation points
    2024-02-07T13:53:42.5533333+00:00

    Power BI is a data consumer as any other SQL client; why should there by any limitation especially for Power BI?

    0 comments No comments

  2. LiHongMSFT-4306 26,621 Reputation points
    2024-02-08T03:22:13.7133333+00:00

    Hi @Anita Rani

    Not an expert on Power BI. So, it is suggested that you post this on Power BI forum.

    Best regards,

    Cosmog Hong


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.