Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
I'm trying to set up a PBIDS file (as per the October release) to define a data source (SQL Server tables) which will prompt the user on Power BI Desktop, to connect to the data source specified in the PBIDS file.
I have trouble accessing a particular schema or multiple objects - I want the user to have access only to a single schema or multiple objects. I get an error which says "Invalid Data Source" or I get the error - Details: "The key didn't match any rows in the table." if I use the file below (with proper database, schema & object names),
{ “version”: “0.1”, “connections”: [ { “details”: { “protocol”: “tds”, “address”: { “server”: “server-name-here”, “database”: “db-name-here”, "schema": "schema-name-here", "object": "[table1, table2, table3]" } }, “options”: {}, “mode”: “Import” } ] } }
However, if I remove multiple object names and use only one object name, or remove the schema & object names it works.
Has anyone used this method before or know how I can define multiple SQL tables in a PBIDS file?
These links have examples of data source files - https://docs.microsoft.com/en-us/power-bi/desktop-data-sources#using-pbids-files-to-get-data
https://docs.microsoft.com/en-gb/azure/data-catalog/data-catalog-dsr#data-source-reference-specifica...
Any help will be appreciated! Thanks
Hi there,
The original blog (and corresponding docs) say:
"The .PBIDS file does not include authentication information and table and schema information."
This might be why you can't get it to work. Interesting, though, that you're able to specify a single table to connect to, despite the above message.
Hope this is useful,
Ed
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |