PowerBI Overview: Difference between revisions

From Data Islands
No edit summary
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]]




'''PowerBI Authentication'''


we are also sending mail to logged user to validate authentication for PowerBI, once user try to add server as powerbi, so below are the subject/body of mail:


Subject: PowerBI Authentication
Body: We have initialized PowerBI authentication, please return to the console and click Enter to continue (if you have not already done so).




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