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.
I'm familiar with pulling in multiple data sources into a single model but I ran into some issues and I'm looking for advice on the next steps.
Today, I connected a new file to a PowerBI dataset and it prevented me from connecting to any other data sources in that file, I tried this multiple times/multiple ways to make sure I wasn't doing something wrong and I received a dialog box that told me it couldn't be done (vs just graying out the 'get data' options). Ok, I get that this won't work; no problem, now I need to look for other solutions.
My next idea is to pull the data directly from a SQL query. But before I set this up, I want to know whether or not I'm going to run into the same problem. If I connect to a SQL query, will I still be able to connect to Salesforce/Excel in the same file?
Solved! Go to Solution.
Hi @CCLARKMC ,
Not sure about SalesForce, but I am able to connect to multible SQL databases and multiple Excel files in one report.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
Hi @CCLARKMC ,
Not sure about SalesForce, but I am able to connect to multible SQL databases and multiple Excel files in one report.
Let me know if you have any questions.
If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel
Proud to be a Super User!
That's good enough validation for me to move onto the next step. Thanks!
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.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |