Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
You read that right, I don't want a Dataflow to query a SQL Server, but rather a SQL Server to query a Dataflow.
Why? The Dataflow is using a Google Analytics API and since it performs well and parses the data, I then want to query that Dataflow and store it in a SQL Table on a daily basis.
Anyone ever done that? Is it possible?
Thanks
Solved! Go to Solution.
I was able to come up with a solution, though a little more excessive than I wanted.
Once it's in the SQL DB, it can be brought back into PowerBI if needed.
Hello @cassidy
I understood why you want to try it but I don't think so Power BI has an API which can help you achieve your desired goal.
All links that can help you with Dataflows
https://radacad.com/category/dataflow
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-features-limitations
Similar thread as per your requirement which also states it is not possible
https://community.powerbi.com/t5/Service/Dataflow-amp-SSMS/td-p/815339
IF YOU LIKE MY ANSWER PLEASE ACCEPT IT AS A SOLUTION AND GIVE KUDOS
Regards,
Nimai
Thanks for the reply @Nimai123 .
I've learned that you can connect to a Dataset in SSMS, so I'm trying to map that to a SQL table. My GA Dataflows would load into a GA Dataset, and then try and pull it from there. So far it does not like mapping something coming from Analysis Services.
Another not so fun option, I've built a Flow that converts the JSON to CSV. Trying to save that CSV to a folder and have SSMS pick it up.
I'll post a solution if I get something reliable.
I was able to come up with a solution, though a little more excessive than I wanted.
Once it's in the SQL DB, it can be brought back into PowerBI if needed.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.