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.
Hello,
We have a report that import views from a SQL Server database on premise. The views uses a linked server. In the desktop we can refresh the data but when we try this in the Power BI Service we get the error: The credentials provided for the SQL source are invalid. We have looked on the rights on the databases, but that doesn't seems to be the problem. Do you know this problem? And so yes, is there a solution or isn't this possible?
Thanks in advance!
Robin
Hi,
Yes i have configured the gateway correctly i think. In another report with also views (without use of a linked server) from a SQL Server it works fine. What do you mean with mapped it on the dataset?
Robin
User | Count |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
51 | |
51 | |
46 |