Forum Discussion

db042190's avatar
db042190
Icon for Impactful Individual rankImpactful Individual
10 months ago
Solved

excel and access to semantic models

Hi, a peer showed me last week that thru excel she has access to a new, sql engine sourced semantic model she stood up.   i dont think she knew exactluy how she stumbled into that.   and honestluy ...
Need Help
  • tayloramy's avatar
    tayloramy
    10 months ago

    Hi db042190, 

     

    In addition to what Greg_Deckler said, it can be even easier! 

     

     

    There is specifically a Power BI option that will allow you to just select a semantic model from a workspace you have access to. 

     

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.


     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 months ago

db042190 This is built into Excel these days. On the Data tab:

 

  • db042190's avatar
    db042190
    Icon for Impactful Individual rankImpactful Individual
    10 months ago

    thx greg, we pivot ssas all the time.   This is a question about a semantic model that was automatically refreshed this morning from a sql engine source...and retrieved in excel from the cloud.