This guide explains how to connect Microsoft Power Platform to Flowsite using Power Query. This connection enables seamless data exchange between Dashpivot and Power Platform, allowing users to import and work with exported data inside Microsoft Dataflows.
Prerequisites
Before you begin make sure you have the following:
Plan: All Plan Types
Permission: Flowsite Contributor
Skills Required: Workflow automation
Device Type: Computer/Browser
Subscription: Flowsite, Dashpivot, Microsoft Power Platform
Step-by-Step Instructions
Open Microsoft Power Platform.
Go to Data flows (if you don't have Data flows added, click into ‘..more’ to pin it to your left navigation).
Create a new Dataflow and give it a name.
Select the Blank Query option.
You will be brought to a script page. Overwrite the existing script with the following:
let
// Define credentials
username = "INSERT",
password = "INSERT",
// Encode the credentials for Basic Authentication
authHeader = "Basic " & Binary.ToText(Text.ToBinary(username & ":" & password), BinaryEncoding.Base64),
// Make the authenticated web request
response = Web.Contents(
"INSERT",
[
Headers = [
Authorization = authHeader
] ] ),
// Parse the CSV response
csv = Csv.Document(response, [Delimiter = ",", Encoding = 65001, QuoteStyle = QuoteStyle.Csv]),
// Promote headers if present in first row
table = Table.PromoteHeaders(csv, [PromoteAllScalars = true])
in
tableOnce the code snippet is added, click Next.
Once the new query is added into Power Query, click ‘Configure Connection’.
In the Connect to data source popup, click the Connect button to finalise the connection.
Once the connection is updated, the data should appear.
Once the data appears, click Next.
In the popup, select the destination for your data by choosing a pre-existing table or creating a new table.
Map the columns from the Dashpivot export to the columns in the destination table, then click Publish.
Once it is published, the new query should appear under Data flows.
Note:
You will need the URL, username, and password provided during the flow creation process.
If you are having trouble creating a dataflow, contact your system administrator to verify that you have the correct permissions.