Forum Discussion

jtwohig01's avatar
jtwohig01
New Member
1 year ago
Solved

Power BI Report Builder Can't find SQL Server

Using the same server and database I connect instantly with SSMS, Power BI Desktop, and Power Query in Excel. However, it won't connect in Power BI Report Builder.   I am trying to create a paginat...
  • jtwohig01's avatar
    jtwohig01
    1 year ago

    There is no gateway involved. It is just an on premises SQL server. There must be something different about how Power Query is implemented in Report Builder from the way it is done in Power BI Desktop or Excel. I ended up creating the report in Excel. Sometimes the old tools still work better than the new ones.