Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Power BI - Data Security

Hello Experts,   I need your help regarding the data security when we publish a report from pbi desktop to power bi server (powerbi.com). Our client has a very secured data and we are using Azure ...
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi LivioLanzo,

 

Do you have any idea :- On which location the power bi has their cloud? Is it in USA or somewhere else? We could mange upto some extent in data resides in USA only. Please advise if you know anything about this.

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi LivioLanzo

     

    Really appreciate all your help!

     

    Thanks

    • v-chuncz-msft's avatar
      v-chuncz-msft
      Community Support
      7 years ago

      Anonymous,

       

      If the post above helps, you may just accept solution. Your contribution is highly appreciated.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi LivioLanzo and v-chuncz-msft

       

      I followed the steps as mentioned in the link to change the source from import to direct query but I need to remove all the query steps before I compile the pbix file. So after the plain table source in direct query mode, I need to again add the steps for my model like add a new column of 'Day of week' from one 'Date' column and so on in query editor but when I try to add a column the step is not getting added and error out like below

       

       

      After google, I found one refernce to enable Composite mode in Preview section but still its getting the same error.

       

      Does anyone has any idea about this?

       

      Please help!

       

      Thank you..

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hello,

        Anyone has any idea about this? I found out that there are lot of limitations while using DirectQuery mode and I assume that this is one of them, but still want to know if anyone has any work around or direct fix?

         

        Please advise.

         

        Thanks