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 have two two databases one is A and other is B. I want know if iwe can combine the databases in paginated reports like power bi, please help me and Which was is better for Dataset creation in paginated reports - via SQL Query or from Power BI Datasets?
Solved! Go to Solution.
In paginated reports a single query can only go against one data source. So if you have multiple tables in your report and you want one to come from each database then that would work fine. If you want to join across the two databases then a Power BI report would be a better option. Or depending on the data sources you may be able to create a linked server or a view across both databases (if both databases are on the same server)
In paginated reports a single query can only go against one data source. So if you have multiple tables in your report and you want one to come from each database then that would work fine. If you want to join across the two databases then a Power BI report would be a better option. Or depending on the data sources you may be able to create a linked server or a view across both databases (if both databases are on the same server)
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 |
---|---|
15 | |
5 | |
4 | |
2 | |
2 |
User | Count |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |