Differences

This shows you the differences between two versions of the page.

--- microsoft_power_bi [2023/03/02 13:09]
windsor_ai
+++ microsoft_power_bi [2024/11/19 13:45] (current)
windsor_ai
@@ Line 7: / Line 7: @@
   - In Power BI select "Get data" from WEB and paste the URL from the onboard form.
-How to get facebook data into powerbi
-{{youtube>0uMPu90whWs?large}}
-{{::powerbi_get_data.png?800|}}
-{{youtube>6xJDClsnhzQ?large}}
-===== How to connect Amazon MWS? =====
-This article here [[https://www.windsor.ai/how-to-connect-amazon-mws-to-power-bi/|Connect Amazon MWS to Power BI]] contains all instructions.
 ===== Why are my numbers multiplied in Power BI desktop? =====
@@ Line 37: / Line 14: @@
 {{ :power-bi_supptdlangs-locale.png?nolink&500 |}}
-===== Pulling data from charts.windsor.ai =====
-. Click explore chart
-{{:powerbi_facebook.png?800|}}
-. Select the fields you want and click JSON to get the URL for the data-feed
-{{:powerbi_facebook_advertising_data.png?800|}}
-. Add this URL to powerbi. It works as a data-feed.
@@ Line 108: / Line 71: @@
 Will load the date range <code>&date_from=2023-01-17&date_to=2023-01-24</code>. You can now manually modify this to adjust your query.
-To only set a start date and default to todays date as end date you would just omit the <code>&date_from=2023-01-24</code> part of the query so the query then would look like this:
+To only set a start date and default to todays date as end date you simply just remove the date_to from the URL. The query then would look like this:
 <code>https://connectors.windsor.ai/facebook?api_key=[API_KEY]&date_from=2023-01-17&fields=account_name,campaign,clicks,date,spend&_renderer=powerbi</code>

Knowledge Base

User Tools

Site Tools

Differences

Page Tools