PowerBI Overview: Difference between revisions
WikiSysopdi (talk | contribs) No edit summary |
WikiSysopdi (talk | contribs) No edit summary |
||
Line 11: | Line 11: | ||
So you would connect the local server to say an MSSQL db, run your querydb, push the data in an island to the Data Islands cloud, change your local server to Power BI and pull/import the island(s) to that. | So you would connect the local server to say an MSSQL db, run your querydb, push the data in an island to the Data Islands cloud, change your local server to Power BI and pull/import the island(s) to that. | ||
''Requirements''' | |||
Power BI license? | |||
''Connecting to Power BI''' | |||
>addserver powerbi "[alias]" | |||
PowerBI Authentication is required at this point so your default browser will open and you connect using your Microsoft Credentials | |||
[[File:power bi auth.png]] | |||
You see what permissions are requested and if you agree click "Accept" - They must be accepted for the system to work. | |||
[[File:power bi permissions.png]] | |||
You then see the approval message | |||
[[File:power bi approved.png]] | |||
You then return to the console app | |||
[[File:power bi console connected.png]] | |||
Using command | |||
>listdb | |||
you will see your workspaces | |||
[[File:powerbi listdb.png]] | |||
To "pull" an island into Pwer BI we then run command | |||
>pull arcustomers arcustomersdemo | |||
[[File:powerbi pull island.png]] | |||
Line 41: | Line 75: | ||
Please note the following console commands not supported for the PowerBI connector: | Please note the following console commands not currently supported for the PowerBI connector: | ||
* DescribeTable | * DescribeTable |
Revision as of 15:38, 20 June 2023
WORK IN PROGRESS
Power BI support Version 1
Power BI has been added as a "local server" connector in the Data Islands console app.
There are some limitations with this over other "local servers" in that you cannot retrive data from Power BI (at least in version 1).
But importantly you can pull/import data to Power BI (from the Data Islands cloud).
So you would connect the local server to say an MSSQL db, run your querydb, push the data in an island to the Data Islands cloud, change your local server to Power BI and pull/import the island(s) to that.
Requirements'
Power BI license?
Connecting to Power BI'
>addserver powerbi "[alias]"
PowerBI Authentication is required at this point so your default browser will open and you connect using your Microsoft Credentials
You see what permissions are requested and if you agree click "Accept" - They must be accepted for the system to work.
You then see the approval message
You then return to the console app
Using command
>listdb
you will see your workspaces
To "pull" an island into Pwer BI we then run command
>pull arcustomers arcustomersdemo
Push datasets limitations In Power BI
Limitations from Microsoft
- 75 max columns
- 75 max tables
- 10,000 max rows per single POST rows request
- 1,000,000 rows added per hour per dataset
- 5 max pending POST rows requests per dataset
- 120 POST rows requests per minute per dataset
- If table has 250,000 or more rows, 120 POST rows requests per hour per dataset
- 200,000 max rows stored per table in FIFO dataset
- 5,000,000 max rows stored per table in 'none retention policy' dataset
- 4,000 characters per value for string column in POST rows operation
- 75 max relationships
- Doesn't work with service principal profiles
Ref: https://learn.microsoft.com/en-us/power-bi/developer/embedded/push-datasets-limitations
Please note the following console commands not currently supported for the PowerBI connector:
- DescribeTable
- NativeSql
- Push
- QueryDB