User Profile
sareed23
Frequent Visitor
Joined 4 years ago
User Widgets
Contributions
Re: Trying setup On Premise Gateway and SAP Hana
KAATA, I do not recall that specific error message, sorry. I would make sure you are adding into the SystemDNS and ensure the port is correct. I will go back thru my notes to see if anything else stood out. Also, I guess to make sure you are using the correct ODBC of 64bit vs 32bit to match your software.8.2KViews1like1CommentRe: Trying setup On Premise Gateway and SAP Hana
I now have the gateway saying successful, I am seeing the dataset in my app.powerbi, i see in settings for the dataset it shows connected to gateway and says I can schedule refresh now too. I went back through from scratch and followed as you described with a pedantic eye to detail. All seems to be working better. I am goign to test the refresh schedule and sharing with others next but I think you answered what I needed. Thank you.8.7KViews0likes0CommentsRe: Trying setup On Premise Gateway and SAP Hana
I did get a message of connection successful in the gateway cluster now. However, if I publish a report from PowerBi Desktop to My Workspace at app.powerbi.com, I get an error message "There is no gateway to access the data source "8.7KViews0likes1CommentRe: Trying setup On Premise Gateway and SAP Hana
I understand about not wanting it on a workstation. My initial hope was to just ttest connecting out and then setting up properly once I understood the process better. As far as the next portion, I had installed the Hana ODBC driver and it created a listing in the ODBC for HDBODBC in the drivers tab. That is what I have been using within PowerBI successfully. I do not have any reference under User DSN nor System DSN currently. When I try to add a System DSN source using the HDBODBC driver, I fail every time at test connection. Most often it is saying it isn't recognizing the database name, which I copied directly from the SAP B1 interface. I have tried using the name of the server found in network dns, i tried using the name of the server found in the SAP interface, tried using the IP. But am not able to get a DSN added.8.7KViews0likes5CommentsTrying setup On Premise Gateway and SAP Hana
Hi, I have tried reading many documents from Microsoft, blogs from people, and posts in this forum. I feel I am missing somethign simple, and turning too many hairs gray. I have SAP B1 Client on my workstation, I have PowerBI Desktop on my workstation. I have HDBODBC installed and PowerBi successfully sees the table structure and can make reports. I installed the On Premise Data Gateway on my workstation and it says successfull. I go to apps.powerbi.com and while the portal looks a bit different than online help, I am able to get the the Gateway clusters, I see the one I made on my workstation and click on the add new data source. I give it a custom name and choose SAP HANA as the source type. From here I have tried most every combination of the below settings. In the server, I have tried the the IP of the server, I have tried the name of the server, tried it with port# after too. In the authentication method, I have tried Basic and I have tried Windows. I have tried my domain credentials, my SAP credentials, I have tried it with and without Validate Server Certificate. Everytime, I get a cogwheel turning at the top of the page that will spin, overnight, few days, until I click something else on the page. I get the following: Activity ID1fcf0e62-c8a4-45b7-94c8-6e1fe71d36bb Request ID130aeaff-d463-c8b6-bab5-5ec0f6b67fb5 Correlation ID8226ca70-3080-95b9-1b02-584bf7940078 Status code404 ecsCorrelationId1fcf0e62-c8a4-45b7-94c8-6e1fe71d36bb TimeThu Dec 23 2021 14:05:43 GMT-0600 (Central Standard Time) Service version13.0.17333.37 Client version2112.2.09063-train Cluster URIhttps://wabi-us-central-a-primary-redirect.analysis.windows.net/ Should I not choose SAP Hana? I did try a couple times with ODBC but I didn't know the connector string. Is there a semantic way I'm not typing in correctly? Thanks in advance.Solved8.9KViews0likes10Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.