The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have a report that uses 2 different databases as sources in the dataset. They play nice when working in desktop. When I upload to the power BI service to publish, they do not and I cant them to work together. I can publish the report using each database source on its own but not together-any thoughts?
It sounds like you need a Power BI Gateway installed. What type of sources is your dataset connected to?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
One is a direct query to a cloud database using snowflake and the other connects via import to an SQL database server
Do you have a Gateway installed on-prem for the SQL Sever source?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Yes I do. As I stated earlier, I can publish each datasource individually, but they do not work together when I combine them.
User | Count |
---|---|
35 | |
14 | |
11 | |
11 | |
8 |
User | Count |
---|---|
44 | |
44 | |
19 | |
18 | |
17 |