Hi, I need to know how to use information sources in power bi, i can’t open examples from doc.ifs. Could any one explain it? I don’t have licences for analasys service I use fact transfer by excel but i don’t know how to use it in power bi.
Question
power bi and information sources
Hi
It’s not clear what you are trying to do. What is meant by you are currently using “Fact transfer by excel”?
If you don’t use any Analysis Models solution, then the only option to connect Information Sources to PBI is using a direct connection to oracle database.
When you connect using IFSINFO user you should be able to see the access views(_BI views) of Information sources.
Then you can create reports using those BI views. You will have to create the fact-dim relationships by matching the correct keys inside the PBI report.
When fetching large data volumes through direct oracle db connection to PBI you might face performance issues for complex information sources.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.