Forum Discussion
Get Data from a PBIDS file
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-specification
Any help will be appreciated! Thanks :smileyhappy:
1 Reply
- ed-freemanAdvocate II
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