CODEWITHSUNDEEP
sql-serverreportreportingpowerbi
LeChuck
LeChuck

Reputation: 71

Select specific tables from an SQL data source in Power BI

I'm working on setting up PowerBI desktop for a client where they'll import 8 specific tables from a database to work on in Power BI.

However, when I go to import the tables, every table in the database is shown and the specific tables must be selected. There are hundreds of tables imported, and a lot of scrolling to select the correct tables, which leaves room for confusion and error for the clients.

The client accesses the database using windows authentication, and I can't change their settings on SSMS as that would affect how they access data on other applications.

I was wondering if there was an simpler way to save a query in Power BI the users can quickly select when setting up a new report.

Upvotes: 0

Views: 1359

Answers (1)

user5226582
user5226582

Reputation: 1986

You could always use raw sql instead:

enter image description here

Or select "empty query" and specify it like so:

enter image description here

Edit: not sure if this is of any help but there's also a filter field:

enter image description here

Upvotes: 2

Related Questions