Comments (7)
from pbiconnectors.
from pbiconnectors.
I took a look at the changes you need.
If was easy for me to add the actions column list (and expanding, pivoting etc. in to separate columns for each action). But it became apparent to me when adding the action_values list column that when these are empty they are difficult to handle without cluttering up the M steps afterwards.
I think it's a better approach to take out these lists in separate tables since PBI is excellent at combining them. The only hurdle here is that PBI doesn't do multicolumn key relations. So we need to add a composite text column containing date, ad_id, adset_id and campaign_id.
Now PBI will automatically relate these tables (if not disabled in the PBI settings).
One advantage with this method is it that other users of the connector take out the level of detail they need. One can skip taking out actions and action_values if you don't need them - taking less time to extract from FB.
I can't exactly break-down in my head if my proposed solution should be cause to some obstacles when making calculated measres/columns in DAX.
Any thoughts?
from pbiconnectors.
Thanks, sounds like we're on the same page.
I'll add the new tables and the key binding them all.
from pbiconnectors.
Let me hear what you think :)
from pbiconnectors.
Hi -
Wanted to let you know that I've seen this!
Thanks for doing it!
Right now I'm hitting rate limits with the actions and action values queries - I'm still troubleshooting to see if it's a local problem with the ad accounts I'm trying to look at, or if it's something that's going to affect users more generally.
The original two queries - ad insights and active ad insights - both seem to function well. Maybe I'm just under my limits with those queries and the trouble starts because the actions/action values return more data per call? Maybe I'll filter to the specific actions I need?
Another thing I'm trying is reducing the date preset from lifetime to 90 days, 14 days, etc, to see if that helps.
Ideally I can get this figured out without resorting to batched or asynchronous requests. I'll post here with what I can come up with.
-AS
from pbiconnectors.
from pbiconnectors.
Related Issues (20)
- API Throttling HOT 4
- Snapchat Connector HOT 1
- Please HELP! connected_instagram_account not connect... HOT 1
- Facebook oAuth Dialog window does not close HOT 2
- Facebook Ads does not load ad accounts in navigator HOT 4
- Facebooks Ads does not load any table
- Error using LinkedIn connector "The redirect_uri does not match the registered value" HOT 1
- Custom connector teamleader crm
- Linkedin connector: redirect URL error
- Facebook Ads: Refresh in PowerBI Web not working HOT 1
- Facebookads connector HOT 2
- Linkedin Connector HOT 2
- Instragram Follower count
- Facebook API v7 FIX HOT 1
- Multiple Instagram Accounts HOT 2
- Error fetching data Facebook Ads
- Upgrade PBIConnectors HOT 2
- Power BI Rest API gives 403 Error
- Power BI Rest API gives 401 Error
- Application access error from Facebook Ads Connector HOT 1
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from pbiconnectors.