PowerBI Overview - Revision history

WikiSysopdi at 12:17, 22 June 2023

2023-06-22T12:17:11Z

← Older revision		Revision as of 12:17, 22 June 2023
Line 105:		Line 105:
	* Push		* Push
	* QueryDB		* QueryDB

			'''Connector Limitations'''

			Due to how Microsoft handle Tokens they only live for 1hr 5mins and so this really prevents the Power BI connector being used in an automated job.

			We are looking to see if this can be resolved in future.

2023-06-21T09:20:03Z

← Older revision		Revision as of 09:20, 21 June 2023
Line 46:		Line 46:
	>listdb		>listdb

	you will see your workspaces. Workspaces are what we ~~defined~~ as Databases in the Data Islands console app~~. Datasets in workspaces we define as Tables~~.		you will see your workspaces. Workspaces are what we consider as Databases in the Data Islands console app.

	[[File:powerbi listdb.png]]		[[File:powerbi listdb.png]]
Line 56:		Line 56:
	[[File:powerbi pull island.png]]		[[File:powerbi pull island.png]]

	This data is visible and can be used to build a report in Power BI		This data is visible and can be used to build a report in Power BI.

	[[File:power bi demo island.png]]		[[File:power bi demo island.png]]

	~~And~~ can be used in a Report (Simple Pagination report here)		Note that Datasets in workspaces we consider as Tables.
			The Command

			>dbtables

			will show any datasets in the workspace

			[[File:power bi dbtables.png]]




			Within Poweer BI these datasets can be used in a Report (Simple Pagination report here)

	[[File:powerbi report.png]]		[[File:powerbi report.png]]

2023-06-21T09:16:08Z

← Older revision		Revision as of 09:16, 21 June 2023
Line 46:		Line 46:
	>listdb		>listdb

	you will see your workspaces		you will see your workspaces. Workspaces are what we defined as Databases in the Data Islands console app. Datasets in workspaces we define as Tables.

	[[File:powerbi listdb.png]]		[[File:powerbi listdb.png]]

2023-06-21T08:26:05Z

← Older revision		Revision as of 08:26, 21 June 2023
Line 33:		Line 33:

	[[File:power bi approved.png]]		[[File:power bi approved.png]]

			You will receive an email confirming this

			[[File:power bi email auth.png]]

	You then return to the console app		You then return to the console app

2023-06-20T15:52:12Z

← Older revision		Revision as of 15:52, 20 June 2023
Line 52:		Line 52:
	[[File:powerbi pull island.png]]		[[File:powerbi pull island.png]]

	This is ~~then~~ visible in Power BI		This data is visible and can be used to build a report in Power BI

	[[File:power bi demo island.png]]		[[File:power bi demo island.png]]

2023-06-20T15:51:17Z

← Older revision		Revision as of 15:51, 20 June 2023
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'''		'''Requirements'''

	* Requires a Power BI "Premium Per User" license		* Requires a Power BI "Premium Per User" license
Line 65:		Line 65:
	'''Push datasets limitations In Power BI'''		'''Push datasets limitations In Power BI'''

	''Limitations from Microsoft''		'''Limitations from Microsoft'''

	* 75 max columns		* 75 max columns

2023-06-20T15:51:01Z

← Older revision		Revision as of 15:51, 20 June 2023
Line 18:		Line 18:
	[[File:power bi xmla endpoint.png]]		[[File:power bi xmla endpoint.png]]

	''Connecting to Power BI'''		'''Connecting to Power BI'''

	>addserver powerbi "[alias]"		>addserver powerbi "[alias]"

2023-06-20T15:50:46Z

2023-06-20T15:50:30Z

← Older revision		Revision as of 15:50, 20 June 2023
Line 14:		Line 14:

	* Requires a Power BI "Premium Per User" license		* Requires a Power BI "Premium Per User" license
	* XMLA Endpoint should be set to "Read Write" (Found in Admin Portal)		* XMLA Endpoint (1) should be set to "Read Write" (Found in Admin Portal)

	[[File:power bi xmla endpoint.png]]		[[File:power bi xmla endpoint.png]]

2023-06-20T15:49:59Z

← Older revision		Revision as of 15:49, 20 June 2023
Line 13:		Line 13:
	''Requirements'''		''Requirements'''

	Power BI license?		* Requires a Power BI "Premium Per User" license
			* XMLA Endpoint should be set to "Read Write" (Found in Admin Portal)

			[[File:power bi xmla endpoint.png]]

	''Connecting to Power BI'''		''Connecting to Power BI'''