Forum Discussion

chris__1's avatar
chris__1
Icon for Advocate II rankAdvocate II
2 years ago

Power BI semantic model experience in Excel

I can not seem to get access to this new Excel-Power BI Dataset integration described here:   https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-excel-power-bi-datasets  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi chris__1 ,

Based on the information you have provided, you seem to have checked most of the prerequisites. Let us go through a few steps to troubleshoot further:

  1. Double-check that you have the correct permissions to use the dataset. Being the administrator of the workspace is a good start, but also make sure you have 'build' permissions for the dataset you want to access.
  2. Sometimes there are limitations on the company network that may prevent certain features. Check with IT to make sure there are no network policies or firewall settings preventing integration.

If the Insert Table option does not appear after taking these steps, it may be helpful to know the following information:

  • Can you use the Get Data option to access Power BI datasets from Excel?
  • Have you tried accessing the integration from a different network or device to troubleshoot issues with a specific device or specific network?
  • Do you get any error messages when you try to use the "Insert Table" option, or does the option not appear at all?

Please provide this additional information so that we can further assist you in resolving the issue.

 

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • chris__1's avatar
    chris__1
    Icon for Advocate II rankAdvocate II
    2 years ago

    hello Anonymous thanks for your response.

     

    to your points:

     

    1. I am admin in all workspaces. I tried adding specific build permissions to my user however this seems to have no effect. Is it even possible to do so if you are already admin?

    2. Can you be more specific about this point? My IT department would like to know what they should look for.

     

    To your other points:

    - Yes, I get the "old" connection to PBI datasets from the "Get Data">"From Power BI" menu. I can see and conncet to all my dataset here and that looks like this:

     

    - Yes, I tried using a different network - the new interface with "Insert Table" does not appear.

    -  see screenshot: I do not get to see this option. So no error message either.

     

    Thanks!